On Sat, Jul 28, 2012 at 12:26 PM, Raju s <[email protected]> wrote: > In our application the data is entered continuously and stored in MySql. > Due to some reason if Tomcat is restarted the data entered previously say > 2 hrs before the restart > vanished from MySql. Till this restart we are able to view or modify the > data and the data is stored in MySql > > On Fri, Jul 27, 2012 at 9:39 PM, Balasubramaniam Natarajan < > [email protected]> wrote: > >> On Fri, Jul 27, 2012 at 9:33 PM, Raju s <[email protected]> wrote: >> >> > >> > We don't use transaction /rollback. >> > The default is commit >> > Tomcat or MySql log we could not find any error >> > >> > >> > We have found that MySql is going to autocommit=false mode and storing the data in buffer. This we checked thro' other connection. When we made con.commit then the data is stored in MySql We have not initiated any transaction or set autocommit=false. How MySql switches to that mode? Any help please.
Thanks Raju _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
