Forum Discussion

rhigdon's avatar
rhigdon
New Contributor
16 years ago

No suitable driver found error

Using SOAP UI 3.0
Creating a Groovy script to read data from an Oracle DB.
I'm getting a java.sql.SQLException:No suitable driver found for oracle:thin:@esrchd.scrippsnetworks.com:1521:esrchd.

Here is the code from the script.

import groovy.sql.Sql;
import oracle.jdbc.driver.OracleTypes;

def driver = oracle.jdbc.driver.OracleDriver
def sql = Sql.newInstance("oracle:thin:@esrchd.scrippsnetworks.com:1521:esrchd",
"***",
"******");

I have place the Oracle ojdbc14.jar in the bin\ext directory.  I also shut down and restarted SOAP UI. 

I have this same driver and connection parms working on Oracle SQL developer on the same PC.
  • Jasper175's avatar
    Jasper175
    Frequent Contributor
    13 years ago
    Found a forum where Ole made a note that:

    Namely, drivers have to be put in lib/, not in bin/ext/.

    Makes sense since we're calling the OracleTypes that reside in that directory.

    Once I moved the ojdbc6.jar to that directory it worked.

    Rob Long