Forum Discussion

HFernandez's avatar
HFernandez
New Contributor
10 years ago

SoapUI testStep Datasource Failing in LoadUI

I have a working SoapUI test step that loads data from a MS SQL server. This work fine in SoapUI, but when run from LoadUI in a soapUI runner I get the following error:

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

at java.net.URLClassLoader$1.run(Unknown Source)

at java.net.URLClassLoader$1.run(Unknown Source)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at com.eviware.soapui.support.GroovyUtils.registerJdbcDriver(GroovyUtils.java:120)

at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:55)

at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.getDatabaseConnection(SourceFile:416)

at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.prepare(SourceFile:170)

at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.prepare(SourceFile:419)

at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:137)

at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:47)

at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:139)

at com.eviware.loadui.components.soapui.SoapUISamplerComponent$SoapUITestCaseRunner.run(SoapUISamplerComponent.java:735)

at com.eviware.loadui.components.soapui.SoapUISamplerComponent.sample(SoapUISamplerComponent.java:576)

at com.eviware.loadui.impl.component.categories.RunnerBase.doSample(RunnerBase.java:492)

at com.eviware.loadui.impl.component.categories.RunnerBase.access$700(RunnerBase.java:58)

at com.eviware.loadui.impl.component.categories.RunnerBase$Worker.run(RunnerBase.java:744)

at com.eviware.loadui.util.dispatch.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:197)

at java.lang.Thread.run(Unknown Source)

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:416)

at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.prepare(SourceFile:170)

at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.prepare(SourceFile:419)

at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:137)

at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:47)

at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:139)

at com.eviware.loadui.components.soapui.SoapUISamplerComponent$SoapUITestCaseRunner.run(SoapUISamplerComponent.java:735)

at com.eviware.loadui.components.soapui.SoapUISamplerComponent.sample(SoapUISamplerComponent.java:576)

at com.eviware.loadui.impl.component.categories.RunnerBase.doSample(RunnerBase.java:492)

at com.eviware.loadui.impl.component.categories.RunnerBase.access$700(RunnerBase.java:58)

at com.eviware.loadui.impl.component.categories.RunnerBase$Worker.run(RunnerBase.java:744)

at com.eviware.loadui.util.dispatch.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:197)

at java.lang.Thread.run(Unknown Source)

com.eviware.soapui.support.SoapUIException: Failed to init connection for drvr [com.microsoft.sqlserver.jdbc.SQLServerDriver], connectionString [jdbc:sqlserver://server:1433;databaseName=NAME;user=Username;password=#####]

at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:68)

at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.getDatabaseConnection(SourceFile:416)

at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.prepare(SourceFile:170)

at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.prepare(SourceFile:419)

at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:137)

at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:47)

at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:139)

at com.eviware.loadui.components.soapui.SoapUISamplerComponent$SoapUITestCaseRunner.run(SoapUISamplerComponent.java:735)

at com.eviware.loadui.components.soapui.SoapUISamplerComponent.sample(SoapUISamplerComponent.java:576)

at com.eviware.loadui.impl.component.categories.RunnerBase.doSample(RunnerBase.java:492)

at com.eviware.loadui.impl.component.categories.RunnerBase.access$700(RunnerBase.java:58)

at com.eviware.loadui.impl.component.categories.RunnerBase$Worker.run(RunnerBase.java:744)

at com.eviware.loadui.util.dispatch.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:197)

at java.lang.Thread.run(Unknown Source)






Now after I add the .jar drivers to :

C:\Program Files\SmartBear\LoadUI-Pro-2.7.0\ext

restart LoadUI, I get the next error:


java.lang.NullPointerException

at com.eviware.soapui.impl.wsdl.panels.teststeps.support.NamedParameterStatement.<init>(NamedParameterStatement.java:54)

at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.load(SourceFile:113)

at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.next(SourceFile:497)

at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.run(SourceFile:135)

at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.runTestStep(AbstractTestCaseRunner.java:239)

at com.eviware.soapui.impl.wsdl.testcase.WsdlTestCaseRunner.runCurrentTestStep(WsdlTestCaseRunner.java:52)

at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:152)

at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:47)

at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:139)

at com.eviware.loadui.components.soapui.SoapUISamplerComponent$SoapUITestCaseRunner.run(SoapUISamplerComponent.java:735)

at com.eviware.loadui.components.soapui.SoapUISamplerComponent.sample(SoapUISamplerComponent.java:576)

at com.eviware.loadui.impl.component.categories.RunnerBase.doSample(RunnerBase.java:492)

at com.eviware.loadui.impl.component.categories.RunnerBase.access$700(RunnerBase.java:58)

at com.eviware.loadui.impl.component.categories.RunnerBase$Worker.run(RunnerBase.java:744)

at com.eviware.loadui.util.dispatch.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:197)

at java.lang.Thread.run(Unknown Source)




I'm I missing more files???
How do I get datasource steps in soapui to run in LoadUI?



Next, if I add the .jar drivers to this folder, no more system error, but it is still not working:
C:\Program Files\SmartBear\LoadUI-Pro-2.7.0\lib

if you go to the log here, there is now a new error that was not displayed in the system errors in LoadUI
C:\Users\Myusername\.loadui\logs


2014-08-19 15:01:00,225 INFO [SoapUI] Adding [C:\Program Files\SmartBear\LoadUI-Pro-2.7.0\ext\jtds-1.3.1.jar] to extensions classpath
2014-08-19 15:01:00,226 INFO [SoapUI] Adding [C:\Program Files\SmartBear\LoadUI-Pro-2.7.0\ext\sqljdbc.jar] to extensions classpath
2014-08-19 15:01:00,519 INFO [DefaultSoapUICore] initialized soapui-settings from [C:\Users\Myusername\soapui-settings.xml]
2014-08-19 15:01:00,894 WARN [SoapUIProGroovyScriptEngineFactory] Missing scripts folder [C:\Program Files\SmartBear\SoapUI-Pro-5.0.0\bin\scripts]
2014-08-19 15:01:01,501 INFO [SchemaUtils] Added default schema from /com/eviware/soapui/resources/xsds/xop.xsd with targetNamespace http://www.w3.org/2004/08/xop/include
2014-08-19 15:01:01,564 INFO [SchemaUtils] Added default schema from /com/eviware/soapui/resources/xsds/XMLSchema.xsd with targetNamespace http://www.w3.org/2001/XMLSchema
2014-08-19 15:01:01,566 INFO [SchemaUtils] Added default schema from /com/eviware/soapui/resources/xsds/xml.xsd with targetNamespace http://www.w3.org/XML/1998/namespace
2014-08-19 15:01:01,567 INFO [SchemaUtils] Added default schema from /com/eviware/soapui/resources/xsds/swaref.xsd with targetNamespace http://ws-i.org/profiles/basic/1.1/xsd
2014-08-19 15:01:01,568 INFO [SchemaUtils] Added default schema from /com/eviware/soapui/resources/xsds/xmime200505.xsd with targetNamespace http://www.w3.org/2005/05/xmlmime
2014-08-19 15:01:01,570 INFO [SchemaUtils] Added default schema from /com/eviware/soapui/resources/xsds/xmime200411.xsd with targetNamespace http://www.w3.org/2004/11/xmlmime
2014-08-19 15:01:01,573 INFO [SchemaUtils] Added default schema from /com/eviware/soapui/resources/xsds/soapEnvelope.xsd with targetNamespace http://schemas.xmlsoap.org/soap/envelope/
2014-08-19 15:01:01,582 INFO [SchemaUtils] Added default schema from /com/eviware/soapui/resources/xsds/soapEncoding.xsd with targetNamespace http://schemas.xmlsoap.org/soap/encoding/
2014-08-19 15:01:01,586 INFO [SchemaUtils] Added default schema from /com/eviware/soapui/resources/xsds/soapEnvelope12.xsd with targetNamespace http://www.w3.org/2003/05/soap-envelope
2014-08-19 15:01:01,595 INFO [SchemaUtils] Added default schema from /com/eviware/soapui/resources/xsds/soapEncoding12.xsd with targetNamespace http://www.w3.org/2003/05/soap-encoding
2014-08-19 15:01:10,611 INFO [DefaultSoapUICore] Importing preferences from [C:\Users\SLove\soapui-settings.xml]
2014-08-19 15:01:10,615 INFO [HttpClientSupport$Helper] Updating keyStore..
2014-08-19 15:01:10,820 INFO [WsdlProject] Loaded project from [file:/C:/AIRES-Test-soapui-project.xml]
2014-08-19 15:01:11,073 WARN [SoapUIProGroovyScriptEngineFactory] Missing scripts folder [C:\Program Files\SmartBear\SoapUI-Pro-5.0.0\bin\scripts]
2014-08-19 15:01:11,881 INFO [DefaultSoapUICore] Importing preferences from [C:\Users\Myusername\soapui-settings.xml]
2014-08-19 15:01:11,883 INFO [HttpClientSupport$Helper] Updating keyStore..
2014-08-19 15:01:46,554 ERROR [AbstractTestRunner] Exception during Test Execution
java.lang.IllegalAccessError: class com.microsoft.sqlserver.jdbc.SQLServerConnection$1DTCCommand cannot access its superclass com.microsoft.sqlserver.jdbc.UninterruptableTDSCommand
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at com.eviware.soapui.support.GroovyUtils$DriverProxy.connect(GroovyUtils.java:175)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.eviware.soapui.support.jdbc.JdbcUtils.initConnection(JdbcUtils.java:72)
at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.getDatabaseConnection(SourceFile:416)
at com.eviware.soapui.impl.wsdl.teststeps.datasource.DBDataSource.prepare(SourceFile:170)
at com.eviware.soapui.impl.wsdl.teststeps.WsdlDataSourceTestStep.prepare(SourceFile:419)
at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:137)
at com.eviware.soapui.impl.wsdl.support.AbstractTestCaseRunner.internalRun(AbstractTestCaseRunner.java:47)
at com.eviware.soapui.impl.wsdl.support.AbstractTestRunner.run(AbstractTestRunner.java:139)
at com.eviware.loadui.components.soapui.SoapUISamplerComponent$SoapUITestCaseRunner.run(SoapUISamplerComponent.java:735)
at com.eviware.loadui.components.soapui.SoapUISamplerComponent.sample(SoapUISamplerComponent.java:576)
at com.eviware.loadui.impl.component.categories.RunnerBase.doSample(RunnerBase.java:492)
at com.eviware.loadui.impl.component.categories.RunnerBase.access$700(RunnerBase.java:58)
at com.eviware.loadui.impl.component.categories.RunnerBase$Worker.run(RunnerBase.java:744)
at com.eviware.loadui.util.dispatch.CustomThreadPoolExecutor$Worker.run(CustomThreadPoolExecutor.java:197)
at java.lang.Thread.run(Unknown Source)




by this point I am lost... This should be a simple configuration, how do I get it to work?



thanks
No RepliesBe the first to reply