On Wed, Oct 4, 2017 at 6:15 PM, Jens Alfke <j...@mooseyard.com> wrote:
>> On Oct 4, 2017, at 2:20 PM, Igor Korot <ikoro...@gmail.com> wrote:
>> If I start transaction, all queries were successful, but issuing "COMMIT"
>> On such failure I am going to present an error, but then what happens
>> if I go and try to close the connection?
> If COMMIT fails, you should execute a ROLLBACK to abort the transaction, then
> continue with failure handling. Otherwise yes, the transaction remains open
> and will cause trouble when you try to close the connection.
And if the ROLLBACK fails?
Because it is possible for ROLLBACK to fail. Not just because COMMIT fails.
> sqlite-users mailing list
sqlite-users mailing list