How do I resolve the error "java.lang.RuntimeException: DriverClass not found for database:aurora" in Data Pipeline?
Last updated: 2019-02-27
When I use AWS Data Pipeline with an Amazon Aurora DB cluster, I get the following error: "java.lang.Thread.run(Thread.java:748) Caused by: java.lang.RuntimeException: DriverClass not found for database:aurora."
When you use Data Pipeline with an engine other than MySQL or PostgreSQL, you must specify the location of the JDBC driver.
- Download the JDBC driver for MySQL.
- Copy the .jar file to an Amazon Simple Storage Service (Amazon S3) bucket. Be sure that Data Pipeline has permission to access the bucket.
- Open the Data Pipeline console and then clone your pipeline.
- On the List Pipelines page, choose the Pipeline ID of the new pipeline, and then choose Edit Pipeline to open the Architect page.
- In the right pane, choose Others, and then choose the RdsDatabase object.
- In the Type drop-down list, choose JdbcDatabase, and then enter the following information:
For Password, enter your Aurora DB password.
For Connection String, enter a string similar to the following: jdbc:mysql://database.xxxxxxx.us-east-1.rds.amazonaws.com:3306/database_name. Be sure to use your Aurora DB cluster endpoint and database name.
For Username, enter your Aurora DB user name.
For Jdbc Driver Class, enter com.mysql.jdbc.Driver.
- Choose Add an optional field, choose Jdbc Driver Jar Uri, and then enter the S3 location where you saved the .jar file in step 2 (for example, s3://your_bucket/mysql-connector-java-5.1.45-bin.jar).
- Choose Save and then choose Activate.