Re: [SQLObject] mysql connection losses

[Ian B. <ia...@co...>]

On Mar 17, 2004, at 8:18 PM, David Warnock wrote:
> 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.

It would be easy to add *if* there's an interface to do this with the 
database driver.  If there was, DBAPIConnection.getConnection() could 
ping the database before returning the connection.

--
Ian Bicking | ia...@co... | http://blog.ianbicking.org