Drake, I am using SQLITE in threadsafe mode. Transaction inside another transaction isnt that equivalent of nested transactions? Should that be allowed? I have no problem opening another handle but just trying to understand the intricacies, thanks.
Drake Wilson-3 wrote: > > Quoth cricketfan <srtedul...@yahoo.co.in>, on 2010-11-30 07:49:36 -0800: >> Also not that both threads are >> using the same handle passed by main. > > No, don't do that. Using the same handle in two threads concurrently > can break depending on the SQLite threading mode, and will gain you no > parallelism in the modes where it works. Aside from that, transaction > state is bound to a handle; you're starting a transaction and then > trying to start another one inside it. > > Open two handles instead. > -- View this message in context: http://old.nabble.com/SQLITE-transactions-failing-with-multiple-threads-tp30340806p30343167.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
