Forum Discussion

Dipin's avatar
Dipin
New Contributor
5 years ago

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.* impo...
  • Dipin's avatar
    Dipin
    5 years ago

    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)

richie's avatar
richie
Community Hero
Hey Dipin,

Have a look at the following link....this describes a solution for connecting to an oracle database via groovy. (https://community.atlassian.com/t5/Adaptavist-questions/Groovy-connect-to-Oracle-db/qaq-p/988693)

Also, regarding your connection string. You didnt include the port number (default is 1521 in oracle) nor a Service Name or SID in your last post. Your last post just had the following:

jdbc:oracle:thin:@ldap

But youre gonna need both port and Service Name/SID in the connectiom string i wouldve thought.

Ta

Rich
Dipin's avatar
Dipin
New Contributor
5 years ago

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)