ContributionsMost RecentMost LikesSolutionsRe: Data Base Connection using Groovy Script in SOAP UI The Connection string was good .. My issue was it is not loading the jar from external.. The below code finally helped me directly loading the files.. Now my code is working.. Thanks a lot of all of you guys for helping me here.... def groovyUtils = new com.eviware.soapui.support.GroovyUtils( context ) def classpathHacker = new com.eviware.soapui.support.ClasspathHacker () log.info "utils=" + groovyUtils path = ".../SoapUI-5.4.0/bin/ext" myfile = new java.io.File(path + "/ojdbc8.jar") mystring = "file://" + path + "/ojdbc8.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.Sql import groovy.sql.* import java.sql.SQLException import oracle.jdbc.driver.* //import com.eviware.soapui.support.GroovyUtils.* // Set up database connection properties. def url = 'jdbc:oracle:thin:' def user = '' def password = '' def driver = "oracle.jdbc.driver.OracleDriver" com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("net.sourceforge.jtds.jdbc.Driver") sql = Sql.newInstance(url, user, password,driver) def query = "" def res = sql.execute(query) Re: Data Base Connection using Groovy Script in SOAP UIyeah i am trying to connect to oracle, provided the ConnectionURL below. url = 'jdbc:oracle:thin:@ Re: Data Base Connection using Groovy Script in SOAP UI Tried that and it is not working. Getting the same error Data Base Connection using Groovy Script in SOAP UI I am trying to connect to Data base and getting the below error. Executed the below query and getting some exception in error log.: QUERY : import groovy.sql.Sql //import groovy.sql.* import java.sql.SQLException import oracle.jdbc.driver.* //import com.eviware.soapui.support.GroovyUtils.* // Set up database connection properties. def url = '' /* IMPORTANT: must start with jdbc:mysql:// */ def user = '' def password = '' def driver = 'oracle.jdbc.driver.OracleDriver' // Register the MySQL JDBC driver – required for Groovy to send requests to the database. com.eviware.soapui.support.GroovyUtils.registerJdbcDriver(driver) // Connect to the SQL instance. def sql = Sql.newInstance(url, user, password,driver) // Use the SQL instance. sql.execute('') // Close the SQL instance. sql.close(); Exception : Mon Jun 01 17:57:18 CDT 2020:ERROR:java.lang.ClassNotFoundException: oracle.jdbc.pool.OracleDataSource java.lang.ClassNotFoundException: oracle.jdbc.pool.OracleDataSource at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at groovy.sql.Sql.loadDriver(Sql.java:705) at groovy.sql.Sql.newInstance(Sql.java:445) at groovy.sql.Sql$newInstance.call(Unknown Source) at Script4.run(Script4.groovy:21) at com.eviware.soapui.support.scripting.groovy.SoapUIGroovyScriptEngine.run(SoapUIGroovyScriptEngine.java:90) at com.eviware.soapui.impl.wsdl.teststeps.WsdlGroovyScriptTestStep.run(WsdlGroovyScriptTestStep.java:141) at com.eviware.soapui.impl.wsdl.panels.teststeps.GroovyScriptStepDesktopPanel$RunAction$1.run(GroovyScriptStepDesktopPanel.java:250) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Can anyone help me here ? Setup : I have added the JDBC files in to C:\Program Files\SmartBear\SoapUI-5.4.0\lib andC:\ProgramFiles\SmartBear\SoapUI-5.4.0\bin\ext. Still getting the same error. Did restart after the above setup also Solved