AWS RDS MYSQL database Integration

[Pavan16]

Hello, 

I am trying to connect to MYSQL database in AWS RDS and connection details are below.

Connection URL: jdbc:mysql:aws//Instancename.rds.amazonaws.com:3306

Given credentials and Driver Name: software.aws.rds.jdbc.mysql.Driver

I have downloaded a jar for this from maven repository [aws mysql jdbc 1.1.4.jar] and added it to External jars in file directory.

Please check and let me know if I am using correct URL, jar file and driver


Error: 

• No suitable driver found. Target Error Message: [No suitable driver found for jdbc:mysql:aws//DBNAME.XXXXXX.eu-north-1.rds.amazonaws.com:3306]

[rushikeshvartak]

• Does restart has been performed after uploading jar file ?

[Pavan16]

Yes

[rushikeshvartak]

Does restart of all pods done with help of saviynt support ticket

[Pavan16]

No, Just restarted all services.

[rushikeshvartak]

Raise support ticket to restart all pods and try

[Pavan16]

Is URL and Driver name correct?

[rushikeshvartak · Accepted solution]

• URL Format: jdbc:mysql://Instancename.rds.amazonaws.com:3306/DBNAME
• Driver Class: software.aws.rds.jdbc.mysql.Driver