支持oracle TAF功能的java连接字符串
我们目前使用 Spring JDBC 和 DBCP 的连接池实现来连接到 TAF 支持的 ORACLE 11g2 服务器。
使用的连接字符串是
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST
=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS = (PROTOCOL = TCP)(HOST = **IP1**)(PORT
= 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = IP2)(PORT = 1521)))(CONNECT_DATA
=(SERVER = DEDICATED)(SERVICE_NAME = **service_name**)(FAILOVER_MODE=(TYPE=select)(METHOD=basic))))
查询 v$session 时验证故障转移类型、故障转移方法时。它向任何人都展示了两者。 
应该如何将failover_type 和failover_method 分别设置为SELECT 和BASIC。 
连接字符串中是否存在无效设置，请提出建议。 提前致谢。
We are currently using Spring JDBC with connection pool implementation from DBCP to connect to TAF supportred ORACLE 11g2 server.
connection string used is
jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST
=(LOAD_BALANCE=ON)(FAILOVER=ON)(ADDRESS = (PROTOCOL = TCP)(HOST = **IP1**)(PORT
= 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = IP2)(PORT = 1521)))(CONNECT_DATA
=(SERVER = DEDICATED)(SERVICE_NAME = **service_name**)(FAILOVER_MODE=(TYPE=select)(METHOD=basic))))
When querying v$session to verify failover type ,failover method . It is showing both to none.
What should be done to set failover_type and failover_method to SELECT and BASIC respectively.
Is there any invalid settings in connection string please suggest.
Thanks in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
11.2 oracle jdbc 文档说
“透明应用程序故障转移 (TAF) 是 Java 数据库连接 (JDBC) Oracle 调用接口 (OCI) 驱动程序的一项功能”
您的连接字符串是：
jdbc:oracle:瘦：
因此，为了启用 TAF，您应该使用 jdbc OCI 驱动程序而不是 Thin 驱动程序。我从未使用过 jdbc OCI 驱动程序，但我想您必须安装标准的本机 oracle 客户端或即时客户端。
The 11.2 oracle jdbc documentation says
"Transparent Application Failover (TAF) is a feature of the Java Database Connectivity (JDBC) Oracle Call Interface (OCI) driver"
your connection string is:
jdbc:oracle:thin:
So in order to enable TAF you should use the jdbc OCI driver not the thin one. I never used the jdbc OCI driver but I suppose you must install the standard native oracle client or the instant client.