Forum Discussion

abg's avatar
abg
New Contributor
10 years ago

SoapUI JDBC connection not working in ReadyAPI

Hi-   I'm trying to set up a JDBC connection to a database using a SoapUI project I imported from a colleague. The project works perfectly in SoapUI Pro V5.1.2 but I consistently get an error messa...
prashobkt's avatar
prashobkt
Contributor
10 years ago

 

Try this Groovy

 

import oracle.jdbc.driver.OracleDriver

import groovy.sql.Sql

com.eviware.soapui.support.GroovyUtils.registerJdbcDriver("oracle.rdb.jdbc.rdbThin.Driver")

sql = Sql.newInstance("jdbc:rdbThin://servername:port/dbname","username","password") def query = "select * from table"

def res = sql.rows(query)