cancel
Showing results for 
Search instead for 
Did you mean: 

How JDBC database connection is done in open version of Soap

New Contributor

How JDBC database connection is done in open version of Soap

I am using open version of SoapUI version 5.0.0
I have installed JDBC driver for SQL Server: sqljdbc4.jar and placed inside: C:\Program Files (x86)\SmartBear\SoapUI-5.0.0\bin\ext
copied sqljdbc_auth.dll inside this path: C:\Program Files (x86)\SmartBear\SoapUI-5.0.0\bin

Restarted the SoapUI

Added the Test step: JDBC Request
Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection String: jdbc:microsoft:sqlserver://server/ipSmiley Tongueortname;databaseName=db name;user= userid;password=pwd
but it's not working for me getting error: com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr

Someone posted to register the driver from Soapui -> preferences but did not find any option in open version.
Can anyone please help me in providing me the exact steps that i need to perform?

Thanks
3 REPLIES 3
Community Hero

Re: How JDBC database connection is done in open version of

Check if below link helps
viewtopic.php?t=4988


Regards,
Rao.
New Contributor

Re: How JDBC database connection is done in open version of

Please provide detailed steps:
I am getting below error:

2014-12-29 17:19:46,533 ERROR [errorlog] 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.panels.teststeps.JdbcRequestTestStepDesktopPanel$TestConnectionAction.actionPerformed(JdbcRequestTestStepDesktopPanel.java:659)
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)
Community Hero

Re: How JDBC database connection is done in open version of

From the stacktrace it is clear
No suitable driver
.
I do not think any details are required other than what you are doing, just that keep right library file.
http://www.soapui.org/Data-Driven-Testi ... Pages.html


Regards,
Rao.
New Here?
Join us and watch the welcome video:
API Testing Mistake #2
APITestingMistake#2
Top Kudoed Authors