Forum Discussion

Santhu0505's avatar
Santhu0505
New Contributor
9 years ago

No suitable driver found for def sql = Sql.newInstance("jdbc:oracle:thin:id/pwd//host:port/svname:)

I am using ReadyAPI 1.5.0 serviceV for virtualiation. In the response I am trying to connect to DB using following code

 

def sql = Sql.newInstance("jdbc:oracle:thin:id/pwd//host:port/svname:)

This same code is working fine in another machine with another copy of virt srever

 

But in this machine when i am hitting the service in the readyapi error logs i am seeing an error:

 

ERROR [errorlog] java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:max_qfund/tmx2014@//10.241.5.70:1521/TLXVM
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:[id/pwd]@//[host ip/blah blah]
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at groovy.sql.Sql.newInstance(Sql.java:279)
at groovy.sql.Sql$newInstance.call(Unknown Source)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:48)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:113)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:125)
at Script1.run(Script1.groovy:28)
at com.eviware.soapui.support.scripting.groovy.SoapUIGroovyScriptEngine.run(SoapUIGroovyScriptEngine.java:92)
at com.eviware.soapui.support.scripting.groovy.SoapUIProGroovyScriptEngineFactory$SoapUIProGroovyScriptEngine.run(SoapUIProGroovyScriptEngineFactory.java:76)
at com.eviware.soapui.impl.wsdl.mock.dispatch.ScriptMockOperationDispatcher.selectMockResponse(ScriptMockOperationDispatcher.java:97)
at com.eviware.soapui.impl.wsdl.mock.WsdlMockOperation.dispatchRequest(WsdlMockOperation.java:245)
at com.eviware.soapui.impl.wsdl.mock.WsdlMockDispatcher.dispatchPostRequest(WsdlMockDispatcher.java:235)
at com.eviware.soapui.impl.wsdl.mock.WsdlMockDispatcher$1.call(WsdlMockDispatcher.java:116)
at com.eviware.soapui.impl.wsdl.mock.WsdlMockDispatcher$1.call(WsdlMockDispatcher.java:1)
at com.eviware.soapui.model.support.HasMockResultsMockDispatcher.doDispatch(HasMockResultsMockDispatcher.java:72)
at com.eviware.soapui.impl.wsdl.mock.WsdlMockDispatcher.dispatchRequest(WsdlMockDispatcher.java:112)
at com.smartbear.servicev.core.engine.impl.soapui.SoapUIHttpVirt.getHttpVirtResponse(SoapUIHttpVirt.java:257)
at com.smartbear.servicev.core.engine.impl.soapui.SoapUIHttpVirt.regularDispatch(SoapUIHttpVirt.java:223)
at com.smartbear.servicev.core.engine.impl.soapui.SoapUIHttpVirt.regularDispatch(SoapUIHttpVirt.java:1)
at com.smartbear.servicev.core.engine.impl.AbstractVirt.dispatch(AbstractVirt.java:130)
at com.smartbear.servicev.core.model.http.impl.HttpVirtServerHandler.dispatch(HttpVirtServerHandler.java:79)
at com.smartbear.servicev.core.model.http.impl.HttpVirtServerHandler.handle(HttpVirtServerHandler.java:58)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:326)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
at com.smartbear.servicev.core.engine.impl.DefaultVirtConnection.handleRequest(DefaultVirtConnection.java:59)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:410)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

 

 

 

Any help is greatly appreciated. Thanks

-Santhosh

1 Reply

  • nmrao's avatar
    nmrao
    Champion Level 3

    It requires to have driver file to be loaded by readyapi. Can you try copying ojdbc<version>.jar under READYAPI_HOME/bin/ext directory and restart it?