Forum Discussion

yura0000's avatar
11 years ago

Connect to jdbc

Hello,
I am new soapui and need to connect soapui with jdbc to take values from db.
I downloaded jdbc_connector from http://dev.mysql.com/downloads/connector/j/5.0.html and put this zip file into SmartBear\SoapUI-Pro-5.0.0\jre\lib\ext and SmartBear\SoapUI-Pro-5.0.0\bin\ext
I run server on MySQL workbench, then open soapui and trying to add DataSource.

In DataSorce select JDBC.
Then in Driver line i writing: com.mysql.jdbc.Driver
in ConnectionString: jdbc:mysql://127.0.0.1:3306/db_test?user=root&password=PASS_VALUE
in Password: root

My DB named: db_test
user: root
password: root

when i click on TestConnection this error occur:
Failed to init connection for drvr [com.mysql.jdbc.Driver],
connectionString [jdbc:mysql://127.0.0.1:3306/db_test?user=root&password=#####]

Please help me.
  • SiKing's avatar
    SiKing
    Community Expert
    yura0000 wrote:
    ... and put this zip file ...

    You need to extract the zip, and use the .jar file.