All geek questions in one place

Creating a JDBC Connection in SOAPUI

I am new to SOAPUI and am trying to validate queries and procedures using SOAPUI. I looked at the SOAPUI documentation on the network, but I can’t connect to my database. I copied the mysql jar in the SOAPUI lib folder. Exception I get

Tue Nov 08 12:54:51 IST 2011:ERROR:com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [com.mysql.jdbc.Driver], connectionString [jdbc:mysql://DB SERVER IP:PORT/DB NAMES?user=username&password=password]

Can someone tell me what is wrong ... Here are the steps I took in SOAPUI for this JDBC thing: -

 > 1.New project. > 2. Clock on New Project. > 3.Go to JDBC Connections tab. > 4. Add a new Data Connection. > 5. Specified unique name. > 6. selected driver as mysql:com.jdbc.driver > 7.I can only see to mention host,port and DB. > 8.Mentioned Host,Port and DB.. > 9.Tested the Connection. > 10.Got the above mentioned excpetion...

Please help someone ...

+6
source share
7 answers

You can try the following. I had the same problem and the following worked for me:

  • Download the JAR for MySQL again. In my case, it happened that the JAR itself was damaged.
  • Copy the JAR to the% soapUI% \ bin \ ext folder
+13
source

It worked great for me!

+5
source

The jar driver must be in the ext folder, and you also need to register the driver before using it. For example, to register the use of the postgresql driver:

 com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("org.postgresql.Driver")
+1
source

What worked for me:

Copy the ojdbc6.jar folders to lib and ext .

+1
source

For me, working with mysql jar in the lib folder worked <% soapUI% / lib> and not <% soapUI% / bin / ext>

+1
source

check connection strings. It could be different. Are you trying to add data source usage? or script?

0
source

Remember to reboot as soon as you download the driver and include it in the directory.

0
source

Source: https://habr.com/ru/post/901001/

More articles:


All Articles