users@glassfish.java.net

Re: RE: Communications Exception after wait_timeout expires in MySQL 5

From: <glassfish_at_javadesktop.org>
Date: Thu, 18 Jun 2009 23:31:30 PDT

Mysql documentation says that autoReconnect has its own side effects like some of the following:
- active transactions are rolled back
- auto commit mode is reset
Could you try setting the non-transactional-connections attribute to true?

Also, please attach the server.log so that nested exceptions can be seen.
[Message sent by forum member 'sm157516' (sm157516)]

http://forums.java.net/jive/thread.jspa?messageID=352024