[Ilugc] MySql data vanishes when tomcat is restarted

Raju s rajusns at gmail.com
Tue Aug 28 18:08:07 IST 2012


On Sat, Jul 28, 2012 at 12:26 PM, Raju s <rajusns at gmail.com> 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 <
> bala150985 at gmail.com> wrote:
>
>> On Fri, Jul 27, 2012 at 9:33 PM, Raju s <rajusns at gmail.com> 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


More information about the ilugc mailing list