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 <ikoro...@gmail.com> wrote: >Hi, > >On Wed, Oct 4, 2017 at 6:19 PM, J. King <jk...@jkingweb.ca> 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 <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" 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 >>>sqlite-users@mailinglists.sqlite.org >>>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 >> sqlite-users@mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >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 sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
