book
Article ID: KB0076725
calendar_today
Updated On:
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.
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
Issue/Introduction
Validation of the data source template definition failed for Amazon Athena