Perhaps I need to be more explicit: If the transaction fails because of a constraint violation, then using either the ROLLBACK, IGNORE, or REPLACE conflict resolution strategies would commit or roll back the transaction and automatically close it. If you add conflict clauses to table schemata, it wouldn't even require changes to the logic of your application.
On October 4, 2017 10:20:01 PM EDT, Igor Korot <[email protected]> wrote: >Hi, > >On Wed, Oct 4, 2017 at 6:19 PM, J. King <[email protected]> wrote: >> See also: >> <http://sqlite.org/lang_conflict.html> > >This is good to know but I don't think it is applicable in this case >as I explicitly said >that this is inside transaction which fails. > >Thank you. > >> >> On October 4, 2017 6:15:55 PM EDT, Jens Alfke <[email protected]> >wrote: >>> >>> >>>> On Oct 4, 2017, at 2:20 PM, Igor Korot <[email protected]> wrote: >>>> >>>> If I start transaction, all queries were successful, but issuing >>>"COMMIT" fails. >>>> 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. >>> >>>—Jens >>> >>>_______________________________________________ >>>sqlite-users mailing list >>>[email protected] >>>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> >> -- >> Sent from my Android device with K-9 Mail. Please excuse my brevity. >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >_______________________________________________ >sqlite-users mailing list >[email protected] >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users -- Sent from my Android device with K-9 Mail. Please excuse my brevity. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
