We help IT Professionals succeed at work.
Get Started

JDBC thin driver TAF

syed_dba
syed_dba asked
on
3,000 Views
Last Modified: 2012-05-10
I know JDBC thin driver doesn't support failover or TAF but my question  is what is the usage of the JDBC url with the failover parameters? i have seen people using it .Our application team is using the jdbc thin driver with the service name(11gr2) and one of the DBA was saying as we're using SCAN NAME in the service which is TAF enabled so load balancing and failover of session/select queries is happening?I'm all confused, one side the docs says its not supported and other side the apps team/DBA team before i joined here has tested failover and are saying its working as expected.How to prove them wrong that TAF doesn't work with thin client.

Is there any difference between thin and OCI drivers in 11g in terms of performance and security,another DBA is suggesting that we should use jdbc thin because of security.Are there any security issues with OCI?

What is it that i need to do as a DBA to setup FCF ?
Comment
Watch Question
Database Administrator
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE