Oracle JDBC (MOSC)

MOSC Banner

Creating Pool Connection we got this error "Timer already cancelled"

edited Mar 17, 2025 11:19AM in Oracle JDBC (MOSC) 5 commentsAnswered

Using OJDBC 21.6.0.0 we got this error below using this 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 told me, that is not necessary to add the unit to CONNECT_TIMEOUT and to TRANSPORT_CONNECT_TIMEOUT).

But when I add the SEC unit after like (CONNECT_TIMEOUT=90 sec) that is works.
Someone had the same issue and how to fix this or the documentation is wrong?

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center