Forum Discussion

Oskar's avatar
Oskar
New Contributor
9 years ago

How to use a preconfigured Database connection in Groovy

Hi, I created an environment with a database connection and would like to use it also in a groovy script. Has anybody a code example for this?   Cheers, Oskar
  • Oskar's avatar
    Oskar
    9 years ago

    I used environment parameters to do this in SOAP UI NG

     

    import groovy.sql.Sql
    import java.sql.SQLException

    try {

     

    def testDbUser = testRunner.testCase.testSuite.project.getPropertyValue("dbusername")
    def testDbPass = testRunner.testCase.testSuite.project.getPropertyValue("dbpassword")
    def testDbHost = testRunner.testCase.testSuite.project.getPropertyValue("dbhost")
    def testDbPort = testRunner.testCase.testSuite.project.getPropertyValue("dbport")
    def testDbServ = testRunner.testCase.testSuite.project.getPropertyValue("dbservicename")

    def db = [url:'jdbc:oracle:thin:@'+testDbHost+':'+testDbPort+'/'+testDbServ, user:testDbUser, password:testDbPass, driver:'oracle.jdbc.driver.OracleDriver']
    def sql = Sql.newInstance(db.url, db.user, db.password, db.driver)
    log.info("using connection " + testDbUser + " " + db.url)

    sql.execute ("some sql")
    sql.execute ("commit")
    log.info("mandate data removed...")
    }
    catch (SQLException e){
    def tmp = e.getSQLState ()
    log.error (tmp, e)
    }

kondasamy's avatar
kondasamy
Regular Contributor
9 years ago

I'm not sure whether you can reuse the database connection that you set-up in JDBC test step through Groovy! And BTW, JDBC connection manager is available only in Pro/ NG version. Digging the SoapUI Pro's Javadoc might give a clue. As of now, I would recommend you to establish a fresh connection to the database.

 

I hope this link would help you to proceed further - http://groovy-lang.org/databases.html

 

Thanks,

Kondasamy

  • Oskar's avatar
    Oskar
    New Contributor
    9 years ago

    I used environment parameters to do this in SOAP UI NG

     

    import groovy.sql.Sql
    import java.sql.SQLException

    try {

     

    def testDbUser = testRunner.testCase.testSuite.project.getPropertyValue("dbusername")
    def testDbPass = testRunner.testCase.testSuite.project.getPropertyValue("dbpassword")
    def testDbHost = testRunner.testCase.testSuite.project.getPropertyValue("dbhost")
    def testDbPort = testRunner.testCase.testSuite.project.getPropertyValue("dbport")
    def testDbServ = testRunner.testCase.testSuite.project.getPropertyValue("dbservicename")

    def db = [url:'jdbc:oracle:thin:@'+testDbHost+':'+testDbPort+'/'+testDbServ, user:testDbUser, password:testDbPass, driver:'oracle.jdbc.driver.OracleDriver']
    def sql = Sql.newInstance(db.url, db.user, db.password, db.driver)
    log.info("using connection " + testDbUser + " " + db.url)

    sql.execute ("some sql")
    sql.execute ("commit")
    log.info("mandate data removed...")
    }
    catch (SQLException e){
    def tmp = e.getSQLState ()
    log.error (tmp, e)
    }