Forum Discussion

ranujn's avatar
ranujn
Contributor
6 years ago
Solved

Having issue while connect to Mysql

I am trying to connect to MySQL. I have provided all the details including port, username, and password when I have clicked on test connection. I can see below message in the ReadyAPI Log "The JDBC...
Nastya_Khovrina's avatar
Nastya_Khovrina
SmartBear Alumni (Retired)
6 years ago

Hi Ranujn,

 

Thank you for your post. Unfortunately, the mentioned docs are outdated, please refer to the following articles to set up the connection:

1. MySQL JDBC Driver: https://support.smartbear.com/readyapi/docs/testing/data-driven/drivers/install/mysql.html

2. Database Manager: https://support.smartbear.com/readyapi/docs/testing/data-driven/drivers/manager.html

3. JDBC Request Test Step: https://support.smartbear.com/readyapi/docs/soapui/steps/jdbc-request.html

 

BTW, getting the "The JDBC driver [com.mysql.jdbc.Driver] is already registered." message is OK.

 

  • ranujn's avatar
    ranujn
    Contributor
    6 years ago

    It seems I am able to connect to DB now. However, when I am running the query it gives me below error message

    It would be really great if you can help me here

    Thu Nov 08 15:25:05 AEDT 2018:ERROR:java.lang.IllegalArgumentException: URLDecoder: Illegal hex characters in escape (%) pattern - For input string: "p{"
    java.lang.IllegalArgumentException: URLDecoder: Illegal hex characters in escape (%) pattern - For input string: "p{"
    at java.net.URLDecoder.decode(Unknown Source)
    at com.mysql.jdbc.NonRegisteringDriver.parseURL(NonRegisteringDriver.java:651)
    at com.mysql.jdbc.NonRegisteringDriver.acceptsURL(NonRegisteringDriver.java:266)
    at com.eviware.soapui.support.GroovyUtils$DriverProxy.acceptsURL(GroovyUtils.java:147)
    at java.sql.DriverManager.getDriver(Unknown Source)
    at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:61)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.ProJdbcSubmit.getDatabaseConnection(ProJdbcSubmit.java:18)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.prepare(JdbcSubmit.java:216)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:173)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:147)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

    Is something I am missing here..