HI ,
I am trying to connect the DB using the JNDI connection with the followong details
<Resource name="jdbc/YATRA" auth="Container" scope="Shareable" type="oracle.jdbc.pool.OracleDataSource" driverclassname="oracle.jdbc.driver.OracleDriver" factory="oracle.jdbc.pool.OracleDataSourceFactory" url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=host1)(PORT=1567))(ADDRESS=( PROTOCOL=TCP)(HOST=host2) (PORT=1567)))(CONNECT_DATA=(SERVICE_NAME=dbcustom)))" user="dbcust1" password="dbcust" connectionCachingEnabled="true" connectionCacheName="BCIFCache" removeExistingOracleConnectionPoolIfExists="true" connectionCacheProperties="{MaxLimit=50, MinLimit=5, InitialLimit=5, ConnectionWaitTimeout=60,ValidateConnection=true}" />
i am unable to connect the DB it is giving me network adaptor Error.
If i am trying to connect using url
jdbc:oracle:thin:@host1:1567:dbcustom1
i am getting the connection to DB.
Here i need to use load balance to connect two DB's.
Please let me know is there any solution for this.
i tried pinging as well as telnet to the two ports both are running.