Contributions
Re: Resolved:JDBC Request not working in 5.0.0
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. Trish10 years agoPlace ReadyAPI QuestionsReadyAPI Questions2.5KViews0likes0CommentsRe: Resolved:JDBC Request not working in 5.0.0
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!10 years agoPlace ReadyAPI QuestionsReadyAPI Questions2.5KViews0likes0CommentsResolved:JDBC Request not working in 5.0.0
I have several projects that contain many JDBC Request test steps. They currently are working fine in 4.6.4-m-SNAPSHOT. I installed 5.0.0 this morning and selected the JDBC drivers at install. I opened one of my projects in the new version and none of my JDBC Request test steps will run successfully. This is my driver: oracle.jdbc.driver.OracleDriver This is my connection string: jdbc:oracle:thin:${#Project#dvUserName}/PASS_VALUE@${#Project#ConnectionString} My password is also a project variable so that it changes with each environment: ${#Project#dvPassword} I don't understand why this works in 4.6.4 but not in 5.0.0. Will you please help me? Trish10 years agoPlace ReadyAPI QuestionsReadyAPI Questions3.7KViews0likes5Comments- 11 years agoPlace ReadyAPI QuestionsReadyAPI Questions8.8KViews0likes0Comments
[Res]SoapUI won't open
On Friday, I exited SoapUI with too many projects loaded and, of course, it was saved this way. Now, I have spent the last 3 hours trying to get SoapUI to open including unstalling and reinstalling. How to I clear the open projects and open SoapUI without any projects (or fewer, smaller projects)? I'm using 4.6.4 Snapshot. I have 4GB of RAM. It opens to 959,264K (in the Task Manager) and stops. I've closed all other programs on my machine and even tried to open it from a freshly booted state. This is really urgent because I'm unable to work and have a deadline. Thanks!11 years agoPlace ReadyAPI QuestionsReadyAPI Questions9.2KViews0likes2Comments[Res] Conditional Goto XPath Expression
I have a REST test case that sometimes returns <m:message>(/var/www/html/websvc/actions/ZZZMF.php) errid (SQCSMF-110)QUOTE NOT SUBMITTED. Quote Header failed trying to populate and create in ZZZMF. Chain Message: (quote_order_hdr_post_ws) parameters:* (XWQC-QH-112) Party Bill_To Site does not exist for p_party_number=3143043 at line:671 in file:/var/www/html/websvc/actions/ZZZMF.php with code:0</m:message> . (ZZZ hides the call name.) The party number would change so I was trying to match *Party Bill_To Site does not exist* like this matches(//m:Quote_Create_Submit_Resp[1]/m:call_status[1]/m:message[1]/text(),'*Party Bill_To Site does not exist*') . This fails. So does matches(//m:Quote_Create_Submit_Resp[1]/m:call_status[1]/m:message[1]/text(),'<m:message>(/var/www/html/websvc/actions/ZZZMF.php) errid (SQCSMF-110)QUOTE NOT SUBMITTED. Quote Header failed trying to populate and create in ZZZMF. Chain Message: (quote_order_hdr_post_ws) parameters:* (XWQC-QH-112) Party Bill_To Site does not exist for p_party_number=3143043 at line:671 in file:/var/www/html/websvc/actions/ZZZMF.php with code:0</m:message>') even though that is the current result of the REST test step. I need the Conditional Goto to run the REST test step again when that message is returned. Please help me with the proper XPath Expression.Solved11 years agoPlace ReadyAPI QuestionsReadyAPI Questions5.7KViews0likes5Comments