Hash: SHA1

Yucca Nel,

On 5/30/2010 1:53 PM, Yucca Nel wrote:
> Ok I need to keep connection open to avoid exceeption but have found
> this is deprecated ....
> autoReconnect=true
> can someone provide up to date strategy for dealing with this?

Don't use autoReconnect as a parameter to the JDBC driver. Instead, use
the "validationQuery" on the connection pool to have the pool verify
that the connection is still valid. MySQL Connector/J even supports a
"ping" query that can gracefully fall-back to driver versions that don't
support it.

I highly recommend that you:

1. Use a Tomcat-configured DataSource
2. Use a DataSourceRealm coupled with #1
3. Tell Hibernate to use #1

That way, all your db configuration is in one place.

Add this parameter to your DataSource configuration (it configures the
connection pool):

validationQuery="/* ping */ SELECT 1"

This will cause the connection pool to execute that query every time a
connection is requested from the pool, just to verify that it's properly
connected. Your web application should never get a dead connection and
therefore shouldn't have to deal with that situation.

- -chris
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/


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

Reply via email to