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.
Invert your Mind 
cool
LikeLike
Great share but i have a question about failover definition.
What will i have to define when i want to describe 2 different SID for failover case ???
In your example there is only one SID (SID=foo)
Best Regards,
Alper.
LikeLike
use service name instead
LikeLike