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)
      }