Using Service name instead of SID in JDBC Oracle Connection

rkonar1 · December 28, 2005, 1:41pm

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.

gupta_r.17495 · December 28, 2005, 10:05pm

Rajib,

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

HTH,
RMG

rkonar1 · December 29, 2005, 6:47am

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

Raymond_Zych1 · December 29, 2005, 8:13am

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.