Forum Discussion

canpan14's avatar
canpan14
Occasional Contributor
9 years ago

Cannot Connect to Oracle RDB Database

I'm trying to connect to an Oracle RDB Database which is not one of the listed databases. I have the driver for it and put it in the bin/ext folder. After trying to fill out the information in JDBC ...
database
drivers
JDBC
oracle
rdb
  • canpan14's avatar
    canpan14
    9 years ago

    Got it to work with:

     

    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)

log.info res[0]

    Looks like I needed the register JdbcDriver part for it to work properly!

prashobkt's avatar
prashobkt
Contributor

canpan14

 

Please provide below details,

a) soapUI version

b)connection string

c)does your password contain "@" symbol

 

or try the below groovy code and check 

 

import  oracle.jdbc.driver.OracleDriver

import groovy.sql.Sql

sql = Sql.newInstance( "jdbc:oracle:thin:@IPAddress/dbName",userName,pwd)

def query = "select * from plksddkd"

def res = sql.rows(query)

 

 

 

canpan14's avatar
canpan14
Occasional Contributor
9 years ago

Got it to work with:

 

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)

log.info res[0]

Looks like I needed the register JdbcDriver part for it to work properly!