Tomcat - Multiple hosts in JDBC connection
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