You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by mischa <mi...@gmail.com> on 2005/11/17 19:58:50 UTC

connection pooling

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

Re: connection pooling

Posted by Clinton Begin <cl...@gmail.com>.

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

Cheers,
Clinton

On 11/17/05, mischa <mi...@gmail.com> 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
>
>
>