> 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 > On Tue, Aug 28, 2012 at 6:43 PM, Girish Venkatachalam < [email protected]> wrote:
> How about switching to postgres? Or sqlite? > We can think of this later,as we cannot tell him that to solve this problem change the database. we have to show the client that we have solved the problem. Raju > _______________________________________________ ILUGC Mailing List: http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
