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. 

  1. Download the JDBC driver for MySQL.
  2. Copy the .jar file to an Amazon Simple Storage Service (Amazon S3) bucket. Be sure that Data Pipeline has permission to access the bucket.
  3. Open the Data Pipeline console and then clone your pipeline.
  4. On the List Pipelines page, choose the Pipeline ID of the new pipeline, and then choose Edit Pipeline to open the Architect page.
  5. In the right pane, choose Others, and then choose the RdsDatabase object.
  6. 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.
  7. 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).
  8. Choose Save and then choose Activate.

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2019-02-28