[sqlite] database corrouption during power failure

[jayanth KP]

  
Hi,
   I have a question regarding power failure handling in sqlite 2.8.3. 

When the power is switched off during  a database write like (insert/update), 
in next reboot database is getting corroupted. 

The database is in a ext3 partition on the harddisk (linux 2.6).


Also i tried the following in my c code after sqlite_open() was success.

sqlite_exec(pDbHandle,"PRAGMA synchronous=FULL;", NULL, NULL, &pErrMsg);

This did not seem to work. 

Please help me in solving this issue


Regards
Jayanth