Home » Server Options » RAC & Failsafe » Does jdbc thin driver support Oracle TAF (ojdbc14.jar v. 10.2.0.4.0)
Does jdbc thin driver support Oracle TAF [message #476332] Wed, 22 September 2010 11:03 Go to next message
nlitvino
Messages: 6
Registered: September 2010
Junior Member
We are trying to move to the Oracle RAC and use TAF in our organization. Does jdbc thin driver v. 10.2.0.4.0 support TAF?
Re: Does jdbc thin driver support Oracle TAF [message #476335 is a reply to message #476332] Wed, 22 September 2010 11:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database JDBC Developer's Guide and Reference
Chapter 28 Transparent Application Failover
First sentence of first section "Overview":

Quote:
Transparent Application Failover (TAF) is a feature of the Java Database Connectivity (JDBC) Oracle Call Interface (OCI) driver


Regards
Michel

[Updated on: Wed, 22 September 2010 11:18]

Report message to a moderator

Re: Does jdbc thin driver support Oracle TAF [message #476353 is a reply to message #476335] Wed, 22 September 2010 13:51 Go to previous messageGo to next message
nlitvino
Messages: 6
Registered: September 2010
Junior Member
In the jdbc connection string we have FAILOVER=on|off What is the usage for this option?

jdbc:oracle:thin:@(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = node 1 IP)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = node 2 IP)(PORT = 1521))((FAILOVER = on)(LOAD_BALANCE = off)(CONNECT_DATA =(SERVICE_NAME = sid)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 160)(DELAY = 5))))
Re: Does jdbc thin driver support Oracle TAF [message #476356 is a reply to message #476353] Wed, 22 September 2010 13:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The fact that you put an option in the connection string does not prove that it is actually used.

Regards
Michel
Re: Does jdbc thin driver support Oracle TAF [message #476358 is a reply to message #476356] Wed, 22 September 2010 14:54 Go to previous messageGo to next message
nlitvino
Messages: 6
Registered: September 2010
Junior Member
I ran a test against Oracle RAC with the TAF configured: set up web application on JBoss to use jdbc thin driver and changed the first node's IP to 1.1.1.1. It actually worked - must of used second (good) IP despite what documentation states.
Re: Does jdbc thin driver support Oracle TAF [message #476362 is a reply to message #476358] Wed, 22 September 2010 15:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You did it before connection time, not during the session.

Regards
Michel
Re: Does jdbc thin driver support Oracle TAF [message #477006 is a reply to message #476362] Mon, 27 September 2010 15:13 Go to previous messageGo to next message
nlitvino
Messages: 6
Registered: September 2010
Junior Member
How about DBD, Perl driver for Oracle? Does it have any support for TAF? Failover support during the connection time would suffice.

Re: Does jdbc thin driver support Oracle TAF [message #477008 is a reply to message #477006] Mon, 27 September 2010 15:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think it should depend on the version and I'm not sure it does it even in the latest version. Just have a look a the documentation of your DBD:Oracle module.

Regards
Michel
Re: Does jdbc thin driver support Oracle TAF [message #478825 is a reply to message #476332] Tue, 12 October 2010 14:27 Go to previous message
nlitvino
Messages: 6
Registered: September 2010
Junior Member
Is there a commercial Oracle driver for Perl that supports TAF?

Previous Topic: 11.2.0.2 Patch for Oracle 11gR2 RAC Cluster
Next Topic: Inserting large data locks the destination table in RAC
Goto Forum:
  


Current Time: Thu Mar 28 07:52:38 CDT 2024