ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Can the JDBC Thin Driver Do Failover by Specifying FAILOVER_MODE?

Can the JDBC Thin Driver Do Failover by Specifying FAILOVER_MODE?

原创 Linux操作系统 作者:zhanglei_itput 时间:2011-04-02 09:47:44 0 删除 编辑
Can the JDBC Thin Driver Do Failover by Specifying FAILOVER_MODE?
  文档 ID: 465423.1 类型: HOWTO
  上次修订日期: 27-APR-2009 状态: PUBLISHED

In this Document
  Goal
  Solution
  References


Applies to:

JDBC - Version: 10.2 to 11.1
Information in this document applies to any platform.

Goal

You have a 2-node RAC database. You ask if the JDBC Thin driver can do failover when using the following connect information.

jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip)(PORT = 1525)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac2vip)(PORT = 1525)) (LOAD_BALANCE = on)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ractest) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 2) (DELAY = 1))))

Solution

No. JDBC Thin cannot use FAILOVER_MODE. The failover defined by FAILOVER_MODE is Transparent Application Failover (TAF). JDBC Thin does not support TAF.
However JDBC Thin does support Fast Connection Failover (FCF).

Some references are:

[1]
The "Is failover supported?" question in the JDBC Frequently Asked Questions (FAQ)
at http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq_0.htm

[2]
Oracle Database JDBC Developer's Guide and Reference, 10g Release 2 (10.2)
at http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/toc.htm
Chapter 27 Fast Connection Failover
Chapter 28 Transparent Application Failover

[3]
Note 433827.1 How To Verify And Test Fast Connection Failover Setup From a JDBC Thin Client

[4]
The "Oracle Real Application Clusters Sample Code" page
at http://www.oracle.com/technology/sample_code/products/rac/index.html
link: **UPDATED** Step by Step Guide and Test Program for JDBC FCF [Nov 2006]
A step-by-step guide to help you set up Fast Connection Failover with JDBC. It also includes a
simple JDBC program that can be used to test your configuration and a sample java program to
subscribe to FAN events for troubleshooting your configuration.

References

Note 433827.1 - How To Verify And Test Fast Connection Failover (FCF) Setup From a JDBC Thin Client
http://download.oracle.com/docs/cd/B19306_01/java.102/b14355/toc.htm

Keywords

RAC; FAILOVER_MODE; JDBC~THIN;

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9252210/viewspace-691541/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-02-10

  • 博文量
    400
  • 访问量
    1129040