Getting Error at JDBC Request : Can't get the Connection for specified properties for MySql connect

[karthikeyanjn1]

Using ReadyAPI 2.1.0 version:

Can't get the connection for specified properties; java.sql.SQLException: IncorrectUrl:

MySql created at AWS

Host: Ju*******

port: 3306

user: root

pass:***

Database: ju***

I have placed the "mysql-connector-java-5.0.8-bin.jar" jar in bin folder.

[nmrao]

If the error is noticed, it says Incorrect Url.

What url have you specified.

By the way, right location to copy library is READYAPI_HOME/bin/ext directory.

[karthikeyanjn1]

Hi Rao,

When i connection via script its working fine but JDBC request configuration. I am getting incorrect URL.

import java.sql.DriverManager
Class.forName("com.mysql.jdbc.Driver")
def conn = DriverManager.getConnection("jdbc:mysql://jupiter***:3306/jupiter","**","***")
def stat = conn.createStatement()
def result = stat.executeQuery("select * from **") 

Even I tried placing the Jar file in ext. it didn't work out.

[nmrao]

That is strange.

Try if the below video helps:
https://www.youtube.com/watch?v=MFPIhG7ixmQ

[karthikeyanjn1]

Hi Rao,

The video which you attached, I have tried it before itself but it didn't work out.

Please find the attached error screenshot and credentials and jar which i am using.

Connecting the DB , Mysql is installed in AWS.

[tlhildebrand]

---

@karthikeyanjn1 wrote:

Hi Rao,

The video which you attached, I have tried it before itself but it didn't work out.

Please find the attached error screenshot and credentials and jar which i am using.

Connecting the DB , Mysql is installed in AWS.

---

I am using MySQL with AWS and I have the same error. Did you find a solution?

[GauravGandhi]

Even I am facing the similar issue when I am trying to make a JDBC request to an AWS RDS(relational database) instance with MySQL.

Through the Groovy and Java Code I am able to make the connection.

Not yet clear why the SOAP UI PRO/ READY API is throwing error like Incorrect URL

java.sql.SQLException: Incorrect URL: jdbc:mysql://abcde.ch1d1floftdg.eu-east-1.rds.amazonaws.com:3306/mydatabase?user=root&password=mydb1243