Oracle database connection - without using setUrl

Question

I am trying to use a datasource to get connection to Oracle database.

I am setting the OracleConnectionCacheImpl object with properties like driverType, networkProtocol, user, password, databaseName, serverName, portNumber.

setUrl cannot be used.

What should I do to get a connection like in the case, if the following url is used ?

jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=service_name)))

I hope I made some sense in what I told.

user1107850 · Accepted Answer · 2012-01-24 06:16:26Z

1

For RAC, you need to set the URL. In my experience, if you do not set the URL explicitly, it will not work in this case. I am unable to comment, hence posting a new reply.

answered Jan 24, 2012 at 6:16

user1107850

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle database connection - without using setUrl

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related