We got the following error when creating a connection pool..
JDBC URL - jdbcurl [jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_TIMEOUT=90)(RETRY_COUNT=50)(RETRY_DELAY=3)(TRANSPORT_CONNECT_TIMEOUT=3)(ADDRESS_LIST =(LOAD_BALANCE=on)(ADDRESS = (PROTOCOL = TCP)(HOST=exaalcvmt01-scan.xxxxxx)(PORT=1521)))(ADDRESS_LIST =(LOAD_BALANCE=on)(ADDRESS = (PROTOCOL = TCP)(HOST=exacibvmt01-scan.xxxxxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME = TVCM16.ORA.XXX.XX)))]
The documentation doesn't specify any details on adding the unit to CONNECT_TIMEOUT and TRANSPORT_CONNECT_TIMEOUT) but when we add the SEC unit after like (CONNECT_TIMEOUT=90 sec) - ((with space)) it works.
Exception is as follows -
Caused by: java.lang.IllegalStateException: Timer already cancelled.
at java.util.Timer.sched(Timer.java:397)
at java.util.Timer.schedule(Timer.java:193)
at oracle.net.nt.TimeoutInterruptHandler.scheduleInterrupt(TimeoutInterruptHandler.java:123)
at oracle.net.nt.TimeoutInterruptHandler.scheduleInterrupt(TimeoutInterruptHandler.java:141)
at oracle.net.nt.TimeoutInterruptHandler.scheduleInterrupt(TimeoutInterruptHandler.java:156)
at oracle.net.nt.ConnStrategy.executeConnOption(ConnStrategy.java:972)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:655)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:584)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:938)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:349)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2442)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:656)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1041)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:89)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:732)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:648)
at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:346)
Could you please review and let us know if this is a BUG (Defect ID?) or some documentation updates are required if working as designed.
Thank you for your help.