Mar 022006

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:


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

  3 Responses to “Fail over in the Oracle JDBC driver”

  1. 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,


 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">



This site uses Akismet to reduce spam. Learn how your comment data is processed.