Demantra Solutions - EBS (MOSC)

MOSC Banner

Tomcat - Multiple hosts in JDBC connection

edited May 17, 2022 6:50AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered

Hi Team,

I am using below configuration currently to connect database from tomcat server.

<entry key="db.hostname">server</entry>

<entry key="db.port">1521</entry>

<entry key="db.servicename">racone.world</entry>

Now , database is hosted/migrated to ODA appliance on server1 and server2. And we got below jdbc connection string

(DESCRIPTION=(CONNECT_TIMEOUT=90)(RETRY_COUNT=50)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1521)))(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=server2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=racone.world)))

We have updated the datasource entry like below:

1) commented below three entries

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center