On 17 Dec 2018, at 9:01am, Prajeesh Prakash <prajeeshprakash@elear.solutions> wrote:
> What are the possible failure cases of DB write in case of single connection. > Because in my application i needs to handle those cases. Can anyone help me > for the same. You state that you're using a single connection. I will assume your software accesses the database only via a single thread, and therefore there can be no contention for using that connection. I will also assume no other program is accessing the database at the same time as the software you're concerned about. If those things are not true, post again explaining the exceptions. For failure cases which can be detected by your software ... Record the value returned from your _step() or _exec() call. Check to see whether this value is SQLITE_OK ( which is 0 ). If it is, the command succeeded. If it isn't, it failed, and your program should report the failure and react to it. It's that simple: check to see that the result is 0, and everything else is a failure. You can unpick this slightly, and detect database rule violations (e.g. SQLITE_CONSTRAINT == 19 , indicating that you've broken database rules you included in the schema) but since your software is meant to be preventing all that, it really doesn't matter what the value is, just report or log it and quit. For a list of result codes see <https://sqlite.org/c3ref/c_abort.html> If the command failed, it never the right thing to do to just have your software try again. For failure cases which cannot be detected by your software, read <https://www.sqlite.org/howtocorrupt.html> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
