Forum Discussion

mohantysuchi's avatar
mohantysuchi
Occasional Contributor
7 years ago

getting class not found exception for oracle jdbc driver in groovy script

I am using groovy scripting in soap ui 5.3.0 to connect oracle DB and  getting the below error while running the script?   java.lang.classNotFoundException:oracle.jdbc.driver.OracleDriver   impor...
New2API's avatar
New2API
Frequent Contributor
7 years ago

Hi Mohantysuchi, try to drop ojbc6 jar in soapui/lib folder as well. 

 

for connection string I am using below convention - 

 

jdbc:oracle:thin:@ServerName:Port/TnsName

 

//## Establish ORACLE connection ##//
def ConnStr = Sql.newInstance(Server, ua, pw, "oracle.jdbc.driver.OracleDriver")

 

hope this solution works!

  • mohantysuchi's avatar
    mohantysuchi
    Occasional Contributor
    7 years ago

    Thanks!!. the solution worked for me.