On Thu, May 17, 2012 at 11:22:44AM -0400, Richard Hipp scratched on the wall: > 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
...which means any "manual" API call to force a sync is also likely to be broken and not work correctly. -j > > 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. -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
