tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael <sg...@gmx.net>
Subject Re: [Tomcat JDBC Pool] Close pooled connections via JMX
Date Sun, 04 Mar 2012 19:45:38 GMT
Pid schrieb:
> On 03/03/2012 12:33, Michael wrote:
>> Hi folks,
>>
>> I've been examining the JMX operations of the new pool and did not find
>> a crucial one.
>>
>> Sometimes our Oracle database has to be restarted, the pool still keeps
>> the pooled connections. The webapp requests a connection, receives a
>> pooled one and boom => ORA-... Connection closed.
>>
>> I'd like to be able via JMX to reopen all open pooled connections
>> without the need to restart the webapp.
> 
> Do you have testOnBorrow="true" and a validationQuery="SELECT 1 FROM
> DUAL" configured?
> 
> This should suffice to ensure each connection is valid before use.

Hi Pid,

I did not yet try that option. Of course, if this works, I'll happy with 
  the "lazy" approach. I will test this the next couple of days and give 
feedback.

Thanks,

Michael

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message