FAQ: JDBC Drivers and Failover Mechanisms (FCF, TAF, SCAN) (Doc ID 1080674.1)

Last updated on MAY 16, 2023

Applies to:

JDBC - Version 11.2.0.1.0 and later
Universal Connection Pool - Version 11.1.0.7.0 and later
Information in this document applies to any platform.

Purpose

Answers to common questions on failover using Oracle JDBC driver

This FAQ covers only Java programs (clients) connecting via JDBC driver. This does not cover failover with other clients such as SQL*Plus, etc.

Questions and Answers

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Questions and Answers

What are the different types of failover mechanisms available ?

Can I use FCF and TAF together ?

Is FCF provided by Oracle JDBC 9i drivers ?

We have been told by Oracle that FCF is not available when using XA JDBC drivers. What HA options are available to us should we wish to use XA?

How do we configure SOA Suite (a simple EE5 application) so that planned and unplanned outages have no impact on applications and that transactions are transparently failed over?

Are there any special database setup configurations that we need to take into consideration when using XA and HA together?

How do we write EE5 code that makes use of SessionBeans, EntityBeans and PersistentManager so that we can provide HA. I have seen examples of FCF and JDBC code that issues a retry when receiving a SQLException. When using EE5 you do not write your code to use JDBC. What options are available to us?

What is SCAN ? Which version of JDBC supports SCAN ?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.