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 driver [com.mysql.jdbc.Driver] is already registered."

So I think its connected but when I am writing a query to build a query section. its again showing the same message in the log and nothing happening. I am not sure where I am wrong.

I followed the instruction from here https://support.smartbear.com/readyapi/docs/testing/data-driven/tutorials/mysql/source.html

Note:-

When I did the step 11, I couldn't see step 12. Step 13 window automatically pop up for me and I am writing the query in the query section and clicks on the button "Build a Query" (In the blog button name is "use a Wizard" but couldn't find in mine.

Nastya_Khovrina
7 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.

Nastya_Khovrina
SmartBear Alumni (Retired)
7 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
  Contributor
  7 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..
  - Nastya_Khovrina
    SmartBear Alumni (Retired)
    7 years ago
    Hi ranujn,
    
    What SQL query do you use?
    
    I've found the following posts about the mentioned issue:
    
    - https://stackoverflow.com/questions/6067673/urldecoder-illegal-hex-characters-in-escape-pattern-for-input-string
    
    - https://stackoverflow.com/questions/11257509/urldecoder-illegal-hex-characters-in-escape-pattern-for-input-string-p/18350056

Forum Discussion

Having issue while connect to Mysql

Related Content

DB Connection Issues

JDBC Connection String, Issue with the password

JDBC connectivity issue - No matching authentication protocol

SOAPUING -Oracle SQL connection establishment issue

LDAPS connection

Recent Discussions

Sudh budh bar hshs the day of

Assert Step Not Executing All Assertions

Include external files (XML) for JDBC connection

Accessing database connection string from groovy test step

JDBC database connection pooling