Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Validation of the data source template definition failed for Amazon Athena

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Validation of the data source template definition failed for Amazon Athena


Solution:

Sometimes the validation for the data source template for Amazon Athena fails even after placing the required JDBC drivers in the tomcat\lib (10.2 and prior) or tomcat\custom-ext (10.3 and onwards) directory. The XML does not get parsed and shows the following status.
  

Validation of the data source template definition failed: Database driver com.amazonaws.athena.jdbc.AthenaDriver not found.


  The issue seems to be most likely with the JDBC Driver version. The XML fails to parse using any of the 2.0.X versions of the driver. To resolve this issue, we can try to instead use the 1.1.0 (AthenaJDBC41-1.1.0.jar) version of the driver which is compatible with JDBC 4.1 and JDK 7.0.

Download Link: https://docs.aws.amazon.com/athena/latest/ug/connect-with-previous-jdbc.html

Related articles