Re: SimplePooledConnection Exception

2009-01-27 Thread Zsolt Koppany
Nathan, we do that. Zsolt Nathan Maves schrieb: Sounds like you need to use a validation query to ensure your connections are not stale. On Sun, Jan 25, 2009 at 10:06 AM, Zsolt Koppany zkoppanyl...@intland.com mailto:zkoppanyl...@intland.com wrote: Hi, after getting the

Re: SimplePooledConnection Exception

2009-01-27 Thread Nicholoz Koka Kiknadze
Maybe it makes sense to switch to DBCP as it has testOnBorrow setting (needs a validation query of course) and the DBCP docs saying: testOnBorrow: The indication of whether objects will be validated before being borrowed from the pool. If the object fails to validate, it will be dropped from the

Re: SimplePooledConnection Exception

2009-01-26 Thread Nathan Maves
Sounds like you need to use a validation query to ensure your connections are not stale. On Sun, Jan 25, 2009 at 10:06 AM, Zsolt Koppany zkoppanyl...@intland.comwrote: Hi, after getting the Exception below I get lot of database related Exceptions. What happens if ibatis finds an invalid

SimplePooledConnection Exception

2009-01-25 Thread Zsolt Koppany
Hi, after getting the Exception below I get lot of database related Exceptions. What happens if ibatis finds an invalid connection? Will that be removed from the pool? What should the application do to prevent such problems? We use ibatis 2.3.4.726 with mysql-5.0.67. Zsolt 2009-01-25