RETRY_COUNT Parameter Works Differently In JDBC Thin Driver
(Doc ID 1364297.1)
Last updated on FEBRUARY 25, 2021
Applies to:JDBC - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 11.2]
Information in this document applies to any platform.
When the JDBC Thin Driver uses RETRY_COUNT in the connection URL, the behavior is incorrect and differs from that of SQL*Plus:
1) Specifying RETRY_COUNT=0 throws a NullPointerException
2) RETRY_COUNT is the total number of trials, not the number of additional attempts.
For example, for RETRY_COUNT=2 , JDBC thin driver will try all the Addresses in
the Address List 2 times, instead of 3 times (1 initial attempt + 2 Retries)
3) Each address in the address list is tried for RETRY_COUNT times before proceeding to the
next address in the list. For example, in a JDBC connection URL, if the first address
cannot be contacted (machine down), this first entry is retried even before trying the other addresses.
The correct behavior is to iterate over all addresses, and if none works, retry the list.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document