Hi guys ,
I am kind of desperately looking around for some JDBC URL String for Oracle 10G RAC to be used in JDBC Pools ( Not the JDBC Adapter) . And we are not using OCI.
I searched around and i could not find anything that works for us.
I have DataDirect Connect for JDBC Release 3.6 Build 0007(SL53_CJ36.Jar)
If you guys could send me a JDBC String that works in your JDBC Pools for a clustered/Failover enabled/Load-balanced environment ,
i would be monumentally indebted to you for the favor.
Thanks in advance.
Sincerely,
-Scoobydoo
Hi - Were you able to figure out how to construct this connection string?
Figured it out. Here’s the general structure of the Database URL:
url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)(HOST=node1)(PORT=1234))(ADDRESS=(PROTOCOL=TCP)(HOST=node2)(PORT=1234)))(CONNECT_DATA=(SERVICE_NAME=myDbService)(FAILOVER_MODE=(TYPE=select)(METHOD=basic))(DELAY=10)(RETRIES=5)))