[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [eclipselink-users] Exception on Mysql Connection
- From: Edilson <johnarevalo@xxxxxxxxx>
- Date: Wed, 29 Oct 2008 10:30:00 -0500
- Delivered-to: email@example.com
- Domainkey-signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=Ft9Z014929gXhHnxf0mUWHxtZIOVy0fSpBSyUbM4RoEa+4aTF0v7/8RlxRYDEXO56Q Lyu2PLh/pV5YHc76g69gdGy2Eb3z37UVI1E8G/t5hV5P5QgiGmKwgDdmn+/DZL7FWwKN x5bFhsBkugu33yeT9KSJpkRjSch/7J4YOEz2o=
2008/9/22 James Sutherland <jamesssss@xxxxxxxxx>:
> You are using a JTA DataSource, so EclipseLink does not control the
> connection. It will get a new connection from the DataSource for each
> request/transaction. Somehow you seem to have a dead connection in your
> >From the error it looks like you may have received an earlier exception
> before this one that caused your connection to be closed, perhaps set
> logging to finest and include the log.
> You could also try using EclipseLink's connection pool instead of the
> DataSource, to confirm the issue is with the DataSource.
Exception didn't appear again after setting in my.cnf
interactive_timeout = 28800
wait_timeout = 28800
mysql idle timeout was closing connections.
do you know how can i setting in Glassfish pool "auto-reconnect"?
PD: in pool properties i've setting this properties, but didn't take effect:
<property name="autoReconnectForPools" value="true"/>
<property name="autoReconnect" value="true"/>
GNU/Linux User #443701