I know this is old dead topic and has been discussed several times on forums. For some reason, I still found myself in a doubt state so thought ask to experts here. I have seen on several threads that TAF does not work with JDBC and we can leverage features like FCF & FAN events for HA features.
says that the Transparent Application Failover feature of the JDBC OCI driver enables you to automatically reconnect to a database if the database instance to which the connection is made goes down. The new database connection, though created by a different node, is identical to the original.
should I assume that jdbc connections works with TAF ? I did a quick test and try to connect my ebiz R12 forms server with TAF service and i could get failover. I am not ebiz expert but i believe Ebiz forms servers also uses JDBC connectivity.
Could you please help me to understand how JDBC OCI than JDBC thin client ? or in simple words, does TAF work with JDBC.
TAF is based on OCI (Oracle Call Interface). So every client using OCI can/may profit from TAF.
JDBC Thick requires an Oracle Client to be installed, hence you have OCI and therefore TAF.
JDBC Thin does not require an Oracle Client to be installed (just the appropriate JAR files) and is not based on OCI, hence NO TAF.
Most JDBC implementations prefer to work with JDBC Thin clients, therefore you will often find JDBC (Thin) does not support TAF. Unfortunately these posts forget to mention the "Thin".