Win a copy of Grokking Bitcoin this week in the Cloud/Virtualization forum!
    Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Frits Walraven
Bartenders:
  • Carey Brown
  • salvin francis
  • Claude Moore

JDBC code for oracle RAC  RSS feed

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi
Can somebody give me the jdbc code to connect to oracle rac.

Sushil.
 
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi,

I dont think there will be any change in the code part, except that you might have to have a JDBC driver (for ex: Oracle Thin driver) that supports Oracle RAC(Oracle Real Application Clusters).

In case if you are using Weblogic Application Server, then you can refer to this link which will help you in setting up the connection to Oracle RAC..
http://e-docs.bea.com/wls/docs81/jdbc/oracle_rac.html

Hope this helps..
 
Jyothi Lature
Ranch Hand
Posts: 60
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi,

JDBC thin driver does not use tnsnames.ora to make a connection.
Using a tnsname here instead of the SID is quite an easy error to make. If it is a name in your TNS file, then replace the host string name with the network name of the Oracle server. That should resolve your problem.

Also, to add to this, some extra info with regard to OCI and Thin driver is...

The JDBC OCI driver provides an implementation of the JDBC interfaces using the Oracle Call Interface (OCI).
The JDBC OCI driver requires an Oracle client installation including Net8.

The JDBC Thin driver establishes a direct connection to the database server using Java Sockets.
The JDBC Thin driver does not require Oracle software on the client side; however, there must be an Oracle listener process correctly installed on the Oracle server.

Hope this helps.


Note:
Please donot use Display Name for the Topic, as this will not help anybody to understand what the topic is all about.
 
Marshal
Posts: 67256
170
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Report post to moderator
Sushil, please respond in the the same topic rather than starting new ones. Please continue this discussion here.
 
I can't renounce my name. It's on all my stationery! And hinted in this tiny ad:
Create Edit Print & Convert PDF Using Free API with Java
https://coderanch.com/wiki/703735/Create-Convert-PDF-Free-Spire
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!