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)

nmrao's avatar
nmrao
Champion Level 3
5 years ago
Restart the tool after placing the driver file under SoapUi installation/bib/ext directory if not already done.
  • Dipin's avatar
    Dipin
    New Contributor
    5 years ago

    Tried that and it is not working. Getting the same error

    • nmrao's avatar
      nmrao
      Champion Level 3
      5 years ago
      Please remove it from lib directory and restart.
      • richie's avatar
        richie
        Community Hero
        5 years ago
        Hi Dipin,

        Can you confirm youre trying to connect to an Oracle database rather than MySQL database?

        Reason i ask is that you make a couple of references to MySQL as well as Oracle in your post.

        For example, your post includes the following lines

        def url = '' /* IMPORTANT: must start with jdbc:mysql:// */
        def user = ''
        def password = ''
        def driver = 'oracle.jdbc.driver.OracleDriver'

        So you appear to be trying to use the Oracle driver, but the comment when you define the url variable (line starting 'def url') indicates the connection URL string should begin 'jdbc:mysql:' rather than what i'd expect it to begin with 'jdbc:oracle:' if you are connecting to an Oracle database. Also make sure you have the parameters in the string setup correctly for Oracle rather than MySQL cos connection URLs differ between database vendors.

        Cheers,

        Rich