Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Exception on Mysql Connection

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
> DataSource.
> >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"/>

Best Regards,

John Arévalo
GNU/Linux User #443701

Back to the top