Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

JDBC URL Syntax

705023Nov 4 2009 — edited Nov 20 2014

Hi

I need help to configure the jdbc url for a datasource in weblogic.

Normally, it would look like this
<url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS= (PROTOCOL=TCP)(HOST=lcqsol24)(PORT=1521))(ADDRESS=(PROTOCOL=TCP) (HOST=lcqsol25)(PORT=1521))(FAILOVER=on)(LOAD_BALANCE=off)) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=snrac)))</url>

However, in my case, each instance has a different service name therefore, is there a way to assign different service name to each address individually?

Also, multi-datasource does not work, so it is not an option.
Thank you

regards
Tony

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2009

Added on Nov 4 2009

#database-connectivity-discussions

5 comments

2,316 views