Hi, This is a well known bug in MySQL driver. It happens after 8 hours of being idle. Try not to use the driver 's default connection pool, use some altetnatives such as C3po.
Best of luck! On 19 Jul 2013 20:33, "Pierre Gilquin" <[email protected]> wrote: > Hi > > If mysql is not accessed by my app for a long period of time (around 8h), > an exception is throwned. > > > Is there a setting that I can apply to my wonder-WO app or mysql to > prevent this ? > > > Thanks in advance > > > Pierre > > > Jul 18 08:31:29 PSF[2016] DEBUG NSLog - 1 row(s) processed > Jul 18 08:31:29 PSF[2016] DEBUG NSLog - === Commit Internal Transaction > JavaClient > Jul 18 18:36:35 PSF[2016] INFO NSLog - Welcome to session > FOMXO0ymbVGulVBtCM4YvM > Jul 18 18:36:43 PSF[2016] DEBUG NSLog - === Begin Internal Transaction > Jul 18 18:36:43 PSF[2016] DEBUG NSLog - evaluateExpression: > <com.webobjects.jdbcadaptor.**MySQLPlugIn$MySQLExpression: "SELECT t0.id, > RTRIM(t0.nom), t0.ordre FROM psf_domaine t0" withBindings: > > Jul 18 18:36:43 PSF[2016] DEBUG NSLog - === Rollback Internal Transaction > Jul 18 18:36:43 PSF[2016] INFO er.transaction.adaptor.**Exceptions - > Database Exception occured: Communications link failure due to underlying > exception: > > ** BEGIN NESTED EXCEPTION ** > > java.io.EOFException > > STACKTRACE: > > java.io.EOFException > at com.mysql.jdbc.MysqlIO.**readFully(MysqlIO.java:1903) > at com.mysql.jdbc.MysqlIO.**reuseAndReadPacket(MysqlIO.** > java:2349) > at com.mysql.jdbc.MysqlIO.**checkErrorPacket(MysqlIO.java:**2860) > at com.mysql.jdbc.MysqlIO.**sendCommand(MysqlIO.java:1571) > at com.mysql.jdbc.MysqlIO.**sqlQueryDirect(MysqlIO.java:**1666) > at com.mysql.jdbc.Connection.**execSQL(Connection.java:2972) > at com.mysql.jdbc.Connection.**execSQL(Connection.java:2902) > at com.mysql.jdbc.Statement.**execute(Statement.java:529) > at com.webobjects.jdbcadaptor.**JDBCChannel._** > bindInputVariablesWithBindings**AndExecute(JDBCChannel.java:**272) > at com.webobjects.jdbcadaptor.**JDBCChannel._**evaluateExpression( > **JDBCChannel.java:337) > at com.webobjects.jdbcadaptor.**JDBCChannel.**evaluateExpression(* > *JDBCChannel.java:296) > at com.webobjects.jdbcadaptor.**JDBCChannel.selectAttributes(** > JDBCChannel.java:220) > at com.webobjects.eoaccess.**EODatabaseChannel._** > selectWithFetchSpecificationEd**itingContext(**EODatabaseChannel.java:897) > at com.webobjects.eoaccess.**EODatabaseChannel.** > selectObjectsWithFetchSpecific**ation(EODatabaseChannel.java:**234) > at com.webobjects.eoaccess.**EODatabaseContext._** > objectsWithFetchSpecificationE**ditingContext(** > EODatabaseContext.java:3055) > at com.webobjects.eoaccess.**EODatabaseContext.** > objectsWithFetchSpecification(**EODatabaseContext.java:3195) > at com.webobjects.eocontrol.**EOObjectStoreCoordinator.** > objectsWithFetchSpecification(**EOObjectStoreCoordinator.java:**488) > at com.webobjects.eocontrol.**EOEditingContext.** > objectsWithFetchSpecification(**EOEditingContext.java:4069) > at er.extensions.eof.ERXEC.**objectsWithFetchSpecification(** > ERXEC.java:1215) > ... > > > ** END NESTED EXCEPTION ** > > > > Last packet sent to the server was 15 ms ago.at com.mysql.jdbc.MysqlIO.** > reuseAndReadPacket(MysqlIO.**java:2561) > at com.mysql.jdbc.MysqlIO.**checkErrorPacket(MysqlIO.java:**2860) > at com.mysql.jdbc.MysqlIO.**sendCommand(MysqlIO.java:1571) > at com.mysql.jdbc.MysqlIO.**sqlQueryDirect(MysqlIO.java:**1666) > at com.mysql.jdbc.Connection.**execSQL(Connection.java:2972) > at com.mysql.jdbc.Connection.**execSQL(Connection.java:2902) > at com.mysql.jdbc.Statement.**execute(Statement.java:529) > at com.webobjects.jdbcadaptor.**JDBCChannel._** > bindInputVariablesWithBindings**AndExecute(JDBCChannel.java:**272) > at com.webobjects.jdbcadaptor.**JDBCChannel._**evaluateExpression(** > JDBCChannel.java:337) > at com.webobjects.jdbcadaptor.**JDBCChannel.**evaluateExpression(** > JDBCChannel.java:296) > at com.webobjects.jdbcadaptor.**JDBCChannel.selectAttributes(** > JDBCChannel.java:220) > at com.webobjects.eoaccess.**EODatabaseChannel._** > selectWithFetchSpecificationEd**itingContext(**EODatabaseChannel.java:897) > at com.webobjects.eoaccess.**EODatabaseChannel.** > selectObjectsWithFetchSpecific**ation(EODatabaseChannel.java:**234) > at com.webobjects.eoaccess.**EODatabaseContext._** > objectsWithFetchSpecificationE**ditingContext(** > EODatabaseContext.java:3055) > at com.webobjects.eoaccess.**EODatabaseContext.** > objectsWithFetchSpecification(**EODatabaseContext.java:3195) > at com.webobjects.eocontrol.**EOObjectStoreCoordinator.** > objectsWithFetchSpecification(**EOObjectStoreCoordinator.java:**488) > at com.webobjects.eocontrol.**EOEditingContext.** > objectsWithFetchSpecification(**EOEditingContext.java:4069) > at er.extensions.eof.ERXEC.**objectsWithFetchSpecification(** > ERXEC.java:1215) > ______________________________**_________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list > ([email protected].**com<[email protected]> > ) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/**mailman/options/webobjects-** > dev/thaominhhoangvn%40gmail.**com<https://lists.apple.com/mailman/options/webobjects-dev/thaominhhoangvn%40gmail.com> > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
