Forum Discussion
Usha_Kodali
16 years agoFrequent Contributor
Hi Ole,
In SoapUI tutorials the connection string for Oracle is for single Host.
I want to multiple hosts.
If I call this function in groovy script it works.
But how do I access sql accross the project and Datasource?
def racdb = new JDBCConnections(log)
def sql = racdb.Connections()
log.info(sql)
def JDBCConnections()
{
String racdb = Sql.newInstance("""jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=******) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=*****) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=******)))""",
"*****","*****",
"oracle.jdbc.driver.OracleDriver")
return racdb
}
In SoapUI tutorials the connection string for Oracle is for single Host.
I want to multiple hosts.
If I call this function in groovy script it works.
But how do I access sql accross the project and Datasource?
def racdb = new JDBCConnections(log)
def sql = racdb.Connections()
log.info(sql)
def JDBCConnections()
{
String racdb = Sql.newInstance("""jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=******) (PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=*****) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=******)))""",
"*****","*****",
"oracle.jdbc.driver.OracleDriver")
return racdb
}