今天测试TAF发 JDBC-THIN 不支持TAF

 查询发现在Doc ID 297490.1有明确说明

APPLIES TO:

JDBC - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 30-July-2013***

Is Transparent Application Failover (TAF) supported on the latest JDBC Thin Driver?

SOLUTION

The Oracle JDBC thin driver does not support TAF. TAF is only supported by the JDBC OCI driver. 

Refer to the documentation listed below.

Oracle Database JDBC Developer's Guide and Reference 10g Release 2 (10.2)

Oracle Database JDBC Developer's Guide and Reference, 11g Release 1 (11.1)

Oracle? Database JDBC Developer's Guide 11g Release 2 (11.2)

Transparent Application Failover

Overview

Transparent Application Failover (TAF) is a feature of the Java Database Connectivity (JDBC) Oracle Call Interface (OCI) driver. It enables the application to automatically reconnect to a database, if the database instance to which the connection is made fails. In this case, the active transactions roll back.

When an instance to which a connection is established fails or is shutdown, the connection on the client side becomes stale and would throw exceptions to the caller trying to use it. TAF enables the application to transparently reconnect to a preconfigured secondary instance creating a fresh connection, but identical to the connection that was established on the first original instance. That is, the connection properties are the same as that of the earlier connection. This is true regardless of how the connection was lost.