Drake,
It is in serialized mode. Opening another handle did resolve the
issue. I am doing inserts in one thread and then if necessary update the
same using another thread.
Drake Wilson-3 wrote:
>
> Quoth cricketfan <[email protected]>, on 2010-11-30 12:11:52 -0800:
>> Drake, I am using SQLITE in threadsafe mode. Transaction inside another
>> transaction isnt that equivalent of nested transactions? Should that be
>> allowed?
>
> SQLite has named savepoints, but not nested BEGIN transactions. It's
> hard to tell what exactly you're doing from the description, such as
> why you're doing these updates with two threads to start with, so it's
> hard to give good advice. Perhaps you could show some example code?
>
> Which threading mode do you mean? Serialized or multithreaded?
>
> ---> Drake Wilson
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/SQLITE-transactions-failing-with-multiple-threads-tp30340806p30343885.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
