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

JDBC connection error indicating SSL issue

DB Connection Issues

JDBC Connection String, Issue with the password

JDBC connectivity issue - No matching authentication protocol

Connection reset

Recent Discussions

Groovy script to access network domain name

ReadyAPI Docker Image COMMAND_LINE -I option is being ignored

AMQP - Cannot connect to ActiveMQ with AMQP Plugin

more screen real estate by moving the Testcase progress bar

JSON Schema Compliance URL