aspose file tools*
The moose likes JBoss/WildFly and the fly likes JDBC connection to Oracle 10g in a RAC cluster Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » JBoss/WildFly
Bookmark "JDBC connection to Oracle 10g in a RAC cluster" Watch "JDBC connection to Oracle 10g in a RAC cluster" New topic
Author

JDBC connection to Oracle 10g in a RAC cluster

Prashant Sehgal
Ranch Hand

Joined: Jun 20, 2003
Posts: 56
Does anyone know if it's possible to connect to a 10g RAC database using the jdbc java thin client.

I'm currently connection to a single node using "jdbcracle:thin:@[HOSTNAME]:[PORT]:[INSTANCE]".

Now another node is being added to make it a RAC cluster, so now there would be two different HOSTNAMEs.

How do I connect to both?
Prashant Sehgal
Ranch Hand

Joined: Jun 20, 2003
Posts: 56
Must mention here that I'm connection from within Jboss 4.0.4 like so:



Yup there's the Oracle9i in the type-mapping, 10g doesn't seem to mind it.
Prashant Sehgal
Ranch Hand

Joined: Jun 20, 2003
Posts: 56
Ok - figured it out from elsewhere. From global benefit, this is how you do it in Jboss:

Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30955
    
158

Prashant,
That was fast! Thanks for sharing the solution.

I'm going to move this to JBoss. It's more for filing at this point - to make it easier for someone doing a search.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
jQuery in Action, 2nd edition
 
subject: JDBC connection to Oracle 10g in a RAC cluster