Chris F
Chris F

Reputation: 16673

How to solve "DriverClass not found for database:mariadb" with AWS data pipeline?

I'm trying to play with AWS Data Pipelines (and then Glue later) and am following Copy MySQL Data Using the AWS Data Pipeline Console. However, when I execute the pipeline, I get

DriverClass not found for database:mariadb

I would expect this to "just work," but why is it not providing it's own driver? Or is driver for MySQL not equal to driver for MariaDB?

Upvotes: 3

Views: 633

Answers (1)

Derek Hobden
Derek Hobden

Reputation: 156

Right, after fighting with this all day, I found the following link which solves it: https://forums.aws.amazon.com/thread.jspa?messageID=834603&tstart=0

Basically: You are getting the error because you are using the RdsDatabase, it needs to be the JdbcDatabase when using mariadb.

"type": "JdbcDatabase", "connectionString": "jdbc:mysql://thing-master.cpbygfysczsq.eu-west-1.rds.amazonaws.com:3306/db_name", "jdbcDriverClass" : "com.mysql.jdbc.Driver"

FULL credit goes to Webstar34 (https://forums.aws.amazon.com/profile.jspa?userID=452398)

Upvotes: 4

Related Questions