This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connection to Oracle 10g in a RAC cluster

 
Prashant Sehgal
Ranch Hand
Posts: 56
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 56
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 56
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok - figured it out from elsewhere. From global benefit, this is how you do it in Jboss:

 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33696
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic