Using Service name instead of SID in JDBC Oracle Connection [Archive]

View Full Version : Using Service name instead of SID in JDBC Oracle Connection

rkonar

12-28-2005, 02:11

Hi,

Can we use Oracle Service name (tnsname.ora entry) instead of providing the SID while creating a JDBC database connection in webMethods 6.1? If yes, how?

Thanks.

rmg

12-28-2005, 10:35

Rajib,

Standard behaviour is providing SID is a must and only way when creating JDBC Adapter Connection otherwise it wont work.

HTH,
RMG

rkonar

12-28-2005, 19:17

Thanks RMG.
Actually another guy in our project was saying that using SID may be troublesome in a oracle cluster environment than service name. Thats why we were looking for ways of creating a jdbc adapter connection through tns service name without referring sid.

Thanks,
Rajib

taz

12-28-2005, 20:43

If your Oracle is in a hardware cluster (HA), you should use a 'logical hostname' which will allow resolution to the SID regardless of which cluster node it is running on.