Hi Richard, Thanks for the reply. fsync() is related to system call, which is working fine. But I am looking for a C API that can do the commit thing, which is same as commit on command promt.
On Thu, May 17, 2012 at 8:52 PM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, May 17, 2012 at 11:18 AM, Rajesh Kumar <thisiz...@gmail.com> > wrote: > > > Hi all, > > > > Am using sqlite database on my ARM processor based Embedded system . > > Whenever power failures or due to uneven shutdown of device, my database > > is being corrupted which leading to data lost. > > > That should never happen. It suggests that fsync() is not working on your > OS. Further information: http://www.sqlite.org/atomiccommit.html and > http://www.sqlite.org/howtocorrupt.html > > > > > Am using C API interface for > > accessing database. Is there any C API that I can use to commit my DB > > manually. I know sqlite has own auto commit mechanism but it's not > working > > for me. > > > > Thanks in advance. > > > > -- > > * > > Thanks & Regards, > > Rajesh Kumar P > > * > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- * Thanks & Regards, Rajesh Kumar P * _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users