Re: [Fwd: [Fwd: Re: connection pooling]]

[mischa]

what happens if the ping fails. does the connection getting removed from 
the pool?
the reason why i don't have pinging enabled is because i want to control 
the case when a connection is closed for one cluster on my own (so i can 
switch to another cluster). even if i could solve the problem by pinging 
the connection i still think it is bad that closed connections are 
getting put back into the pool (or not getting recycled after a certain 
period).

Do you have the ping query (or validation query) enabled?
Cheers,
Clinton

On 11/17/05, *mischa* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> 
wrote:

    is there anything i can do to prevent ibatis from putting back
    connetions to the pool when they are already closed? i am working with
    cluster pairs and when the connection to one cluster fails i am
    switching back to another. it seems like the connection that
    failed/is
    closed is getting put back into the pool and is not getting
    reinitialized by the pool. so even if the first cluster is back
    online i
    am getting a

    Cause: java.sql.SQLException: No operations allowed after
    connection closed.

    any thoughts?
    thanks,
    mischa