Forum Discussion

Mr_Bro's avatar
Mr_Bro
Frequent Contributor
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
2 years ago

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