• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Oracle

 
Murali Koppula
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Java Ranchers,

When I attempt to get a Connection object from the driver manager, I use the syntax (as per Oracle JDBC doc):

Connection conn = DriverManager.getConnection
("jdbc racle ci:@MyHostString", "scott", "tiger");

My question is about the first argument "jdbc racle ci:@MyHostString":
Is 'MyHostString' the service name or the Oracle SID?

Specifically in a RAC environment, where I have multiple instances and a single service, which on do I specify there? Service name or the ORACLE_SID?

Thanks a lot in advance,
Murali.

[edited to disable smilies]
[ September 05, 2004: Message edited by: Jeanne Boyarsky ]
 
Julian Kennedy
Ranch Hand
Posts: 823
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Murali,

From the Oracle Tech Net, found through a Google search on "jdbcracleci", it looks like MyHostString can take the form hostname:port:SID, amongst others. Check out the link for more info.

Jules
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic