JDBC Connections - groovy script
I created groovy scipt for Oracle db connection. I call the script in Project LoadScript as def racdb = new JDBCConnections(log) def sql = racdb.Connections() log.info(sql) How do I access s...
Forum Discussion
Hi Ole,
Can you provide me the connection string atleast which works for clustered database?
I have more than 2 hosts and the SoapUI gives me only one host in the UI
My connection string is like this:
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")
Can you provide me the connection string atleast which works for clustered database?
I have more than 2 hosts and the SoapUI gives me only one host in the UI
My connection string is like this:
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")