RETRY_COUNT Parameter Works Differently In JDBC Thin Driver

(Doc ID 1364297.1)

Last updated on AUGUST 03, 2016

Applies to:

JDBC - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms