Invert Your Mind

Apparently the Oracle JDBC driver supports fail over based on connection creation. I think it will support tnsnames parsing, but I’m not sure. This is supported though:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=example.com)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)
(HOST=failover.example.com)(PORT=1521))
(FAILOVER=true)(LOAD_BALANCE=false)
(CONNECT_DATA=(SERVER=DEDICATED)(SID=foo)))

Not the nicest format, but you only have to do it once and it seems to work pretty well.

This entry was posted on Thursday, March 2nd, 2006 at 2:51 pm and is filed under Java. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.