On 5/11/07, Tworkiewicz, Adam <[EMAIL PROTECTED]> wrote:
Hi,
We use dbcp for connection pooling in our application that talks to
Oracle 10g RAC (2 nodes). Our dbcp config is attached below. We are
seeing undesired behaviour when we test db failover. Since we use load
balancing connections in the pool point to both db servers. When we
shutdown one of the db nodes our ping query hangs waiting for TCP/IP
traffic. Since the box is down there is no traffic and the query hangs
until a TCP/IP timeout occures.
Is there a way to set up a timeout on the validation query?
Currently, there is no way to do that. Would you mind opening JIRA
ticket requesting this feature? You can do that here:
http://jakarta.apache.org/commons/dbcp/issue-tracking.html
Patches welcome.
Phil
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
