Forum Discussion

brainiac007's avatar
brainiac007
Occasional Contributor
11 years ago

soapUI OSS Version - connection to H2 / Derby on MAC OSX 10

Hello everybody

I try to connect from a soapUI OSS Version on MAC OSX 10 to connection to H2 / Derby DB via JDBC
I have put the driver into /Applications/SmartBear/soapUI-4.6.0.app/Contents/java/app/bin but soapUI don't load it...

6 Replies

  • brainiac007's avatar
    brainiac007
    Occasional Contributor
    thnx redfish4ktc2
    sorry I copied the wrong path! The jars are in :/Applications/SmartBear/soapUI-4.6.0.app/Contents/java/app/bin/ext

    I always get the error message:
    com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [org.h2.Driver], connectionString [jdbc:h2:tcp://localhost/~/test]
  • redfish4ktc2's avatar
    redfish4ktc2
    Super Contributor
    ok, the driver is correctly initialize, so the h2 jar is correclty loaded in soapui

    seems the connection string uses tcp
    have you tried to connect with the same connection string using code outside soapui?
  • brainiac007's avatar
    brainiac007
    Occasional Contributor
    attached the error log from soapUI

    Fri Oct 11 15:07:35 CEST 2013:ERROR:java.sql.SQLException: No suitable driver
    java.sql.SQLException: No suitable driver
    at java.sql.DriverManager.getDriver(DriverManager.java:289)
    at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:52)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.getDatabaseConnection(JdbcSubmit.java:218)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.prepare(JdbcSubmit.java:261)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:197)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:161)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
    at java.util.concurrent.FutureTask.run(FutureTask.java:166)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:722)
    Fri Oct 11 15:07:35 CEST 2013:ERROR:com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [org.h2.Driver], connectionString [jdbc:h2:tcp://localhost/~/test]
    com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [org.h2.Driver], connectionString [jdbc:h2:tcp://localhost/~/test]
    at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:64)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.getDatabaseConnection(JdbcSubmit.java:218)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.prepare(JdbcSubmit.java:261)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.runQuery(JdbcSubmit.java:197)
    at com.eviware.soapui.impl.wsdl.panels.teststeps.JdbcSubmit.run(JdbcSubmit.java:161)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
    at java.util.concurrent.FutureTask.run(FutureTask.java:166)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:722)
  • brainiac007's avatar
    brainiac007
    Occasional Contributor
    I guess this is a bug in the MAC version - when I do exactly to same in WIN it works fine....