How about switching to postgres? Or sqlite? On Tue, Aug 28, 2012 at 6:08 PM, Raju s <[email protected]> wrote: > 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
-- Gayatri Hitech http://gayatri-hitech.com _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
