I have used autoReconnect=true in my connection string. Here is an
interesting article about enabling auto reconnect for MySQL 5+.
http://blog.taragana.com/index.php/archive/how-to-enable-disable-auto-reconnect-in-mysql/
There is also some discussion about making sure that autoCommit is
true when using ?autoReconnect=true. Here is a post about why: http://lists.mysql.com/java/4928
On Apr 9, 2008, at 5:36 AM, Jon Loken wrote:
Hi all,
With AppFuse 1.9.3, when using the standard
org.apache.commons.dbcp.BasicDataSource, we are experiencing DB
timeouts
after 8 hours or so with MySql.
Does anyone know of a DB connection pooling project that will keep the
underlying DB session open? Will c3p0 be of help
(http://sourceforge.net/projects/c3p0/)?
Although I am sure it is possible to configure MySql, we are hoping to
address this from the client side.
Thank you,
Jon
BiP Solutions Limited is a company registered in Scotland with
Company Number SC086146 and VAT number 38303966 and having its
registered office at Park House, 300 Glasgow Road, Shawfield,
Glasgow, G73 1SQ
****************************************************************************
This e-mail (and any attachment) is intended only for the attention
of the addressee(s). Its unauthorised use, disclosure, storage or
copying is not permitted. If you are not the intended recipient,
please destroyall copies and inform the sender by return e-mail.
This e-mail (whether you are the sender or the recipient) may be
monitored, recorded and retained by BiP Solutions Ltd.
E-mail monitoring/ blocking software may be used, and e-mail content
may be read at any time. You have a responsibility to ensure laws
are not broken when composing or forwarding e-mails and their
contents.
****************************************************************************
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
