Resolved:JDBC Request not working in 5.0.0

Hello,

can you please send me the error log and SoapUI log that you are receiving after getting the error in the JDBC step? The error log and SoapUI log are located in tabs at the bottom of SoapUI.

Regards,
Temil

This is the error message that pops up:
Failed to init connection for drvr [oracle.jdbc.driver.OracleDriver], connectionString [jdbc:oracle:thin:apps/#####@********]

The stars (*) represent my connection string which is correct. The # symbols are part of the error message.

This is the SoapUI log:
Tue Jun 10 09:08:44 PDT 2014:INFO:Adding [C:\Program Files\SmartBear\SoapUI-Pro-5.0.0\bin\ext\postgresql-8.3-604.jdbc3.jar] to extensions classpath
Tue Jun 10 09:08:44 PDT 2014:INFO:Adding [C:\Program Files\SmartBear\SoapUI-Pro-5.0.0\bin\ext\postgresql-8.3-604.jdbc4.jar] to extensions classpath
Tue Jun 10 09:08:44 PDT 2014:INFO:Adding [C:\Program Files\SmartBear\SoapUI-Pro-5.0.0\bin\ext\sqljdbc.jar] to extensions classpath
Tue Jun 10 09:08:44 PDT 2014:INFO:initialized soapui-settings from [C:\Users\thughes\soapui-settings.xml]
Tue Jun 10 09:08:45 PDT 2014:INFO:Setting Script Library to [C:\PROGRA~1\SMARTB~1\SOAPUI~1.0\bin\scripts]
Tue Jun 10 09:08:45 PDT 2014:INFO:Adding listeners from [C:\Program Files\SmartBear\SoapUI-Pro-5.0.0\bin\listeners\demo-listeners.xml]
Tue Jun 10 09:08:47 PDT 2014:INFO:Loading workspace from [C:\Users\thughes\default-soapui-workspace.xml]
Tue Jun 10 09:08:47 PDT 2014:INFO:Loaded project from [file:/C:/svn_working_copies/intg_wsvc_testing/Entity_Testing/Party_V100-soapui-project.xml]
Tue Jun 10 09:08:48 PDT 2014:INFO:Setting Script Library to [C:\PROGRA~1\SMARTB~1\SOAPUI~1.0\bin\scripts]
Tue Jun 10 09:08:50 PDT 2014:INFO:Loaded project from [file:/C:/svn_working_copies/intg_wsvc_testing/Entity_Testing/Smoke-V101-soapui-project.xml]
Tue Jun 10 09:08:50 PDT 2014:INFO:Setting Script Library to [C:\PROGRA~1\SMARTB~1\SOAPUI~1.0\bin\scripts]
Tue Jun 10 09:08:51 PDT 2014:INFO:Used java version: 1.7.0_40
Scheduling garbage collection every 60 seconds
Tue Jun 10 09:08:54 PDT 2014:INFO:Adding actions from [C:\Program Files\SmartBear\SoapUI-Pro-5.0.0\bin\actions\demo-actions.xml]
Port already in use: 1198; nested exception is:
java.net.BindException: Address already in use: JVM_Bind
Tue Jun 10 09:09:20 PDT 2014:ERROR:An error occurred [No suitable driver], see error log for details

This is the error log:
Tue Jun 10 09:09:20 PDT 2014:ERROR:java.sql.SQLException: No suitable driver
java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(Unknown Source)
at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:56)
at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.getDatabaseConnection(SourceFile:422)
at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.prepare(SourceFile:170)
at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.prepare(SourceFile:459)
at com.eviware.soapui.impl.wsdl.panels.teststeps.DataSourceDesktopPanel$TestAction.actionPerformed(SourceFile:364)
at com.eviware.soapui.impl.wsdl.panels.teststeps.DataSourceDesktopPanel$TestAction.actionPerformed(SourceFile:321)
at com.eviware.soapui.impl.wsdl.actions.iface.AbstractSwingAction.actionPerformed(AbstractSwingAction.java:77)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEventImpl(Unknown Source)
at java.awt.EventQueue.access$200(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.awt.EventQueue$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.awt.EventQueue$4.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

The driver exists under File, Preferences, JDBC Drivers Properties so I'm not sure why it can't find it.

Thanks!

I found out that these two files need to be saved to the /lib directory while SoapUI is closed. When SoapUI is opened, the JDBC connections work as they should. Please consider adding these to the installation.

• classes12.zip
• ojdbc14.jar

Thanks for looking into this.

Trish

This needs to be done every time you install an upgrade. Could these files please be included in the install?

Hello,

Unfortunately that is not possible. Not everybody uses the same types of databases and there are tons of databases out there. If you have further issues or questions please let me know.

Regards,
Temil