Forum Discussion

Mr_Bro's avatar
Mr_Bro
Champion Level 0
2 years ago

how to load driver jar file to connect to database

Hello All,   request you to please suggest how to load an external driver .jar to connectc to database, as i have have required access to add any files or modify any existing files from the c:\ d...
Shashavali's avatar
Shashavali
Contributor

try this

 

def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context )
def classpathHacker = new com.eviware.soapui.support.ClasspathHacker ()

log.info "utils=" + groovyUtils
path = groovyUtils.getProjectPath()
myfile = new java.io.File(path + "/ojdbc14.jar")
mystring = "file://" + path + "/ojdbc14.jar"
log.info "myfile=" + myfile

classpathHacker.addFile( myfile )
com.eviware.soapui.support.ClasspathHacker.addFile( myfile )
com.eviware.soapui.support.ClasspathHacker.addURL( new URL(mystring) )

import groovy.sql.*
def sql = groovy.sql.Sql.newInstance( db, userid, password, 'oracle.jdbc.driver.OracleDriver' )

 

https://community.smartbear.com/t5/SoapUI-Open-Source-Questions/Soapui-is-not-loading-external-jar-file-location-added-to/td-p/7619 

Mr_Bro's avatar
Mr_Bro
Champion Level 0
2 years ago

Shashavali ,

i have tried this approach and im encountring the below error ,

 

java.io.IOException: Error, could not add URL to classloader jdk.internal.loader.ClassLoaders$PlatformClassLoader error