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,
I got the clustered database connection working successfully now
Hope this string helps others who has Oracle DB which has Load Balance set on.
In the JDBC Connections tab at the project level,
Name: QA
Driver: oracle.jdbc.driver.OracleDriver
Connection String: jdbc:oracle:thin:username/password@(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=HOST1)(port=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=HOST2)(port=1521))) (CONNECT_DATA=(server=dedicated) (SERVICE_NAME= SERVER_NAME)))
I got the clustered database connection working successfully now
Hope this string helps others who has Oracle DB which has Load Balance set on.
In the JDBC Connections tab at the project level,
Name: QA
Driver: oracle.jdbc.driver.OracleDriver
Connection String: jdbc:oracle:thin:username/password@(DESCRIPTION=(ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=HOST1)(port=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=HOST2)(port=1521))) (CONNECT_DATA=(server=dedicated) (SERVICE_NAME= SERVER_NAME)))