Validation of the data source template definition failed for Amazon Athena
Article ID: KB0076725
Updated On:
| Products | Versions |
|---|---|
| Spotfire Server | All versions |
Description
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.
Issue/Introduction
Validation of the data source template definition failed for Amazon Athena
Environment
All Supported Operating Systems
Resolution
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
Download Link: https://docs.aws.amazon.com/athena/latest/ug/connect-with-previous-jdbc.html
Feedback
Yes
No
Powered by
