Re: [SQLObject] mysql connection losses

[David W. <da...@su...>]

Victor,

> I'm getting the following error in my application using SQLObject 0.5.1 
> and MySQL.
> 
> Any ideas on how to work around this problem?  I'd like to be able to 
> set an expiry option on the connection pool so that connections will 
> only be used 'N' number of times before they get closed and discarded.

Our Java connection pool tests every connection before it gives it to 
the client (by setting autocommit). If the test fails then the 
connection is removed from the pool and the next connection (or if 
required a new connection) is returned.

We added this because both MySQL and MS SQL Server seemed to not like 
having connections around for long periods of time and would close them 
at inopportune times.

Maybe SQL Object could do something similar.

Regards

Dave
-- 
David Warnock, Sundayta Ltd. http://www.sundayta.com
iDocSys for Document Management. VisibleResults for Fundraising.
Development and Hosting of Web Applications and Sites.