Re: [sqlite] Getting SQLITE_BUSY within a transactionandhow tohandle it

2009-03-18 Thread Marcus Grimm
sorry, I don't know if it is allowed to end a transaction from a different connection than the one that obtained the lock. I would not recommend that, sounds a bit unhealthy from the application point of view. I'm pretty sure that a transaction is partly connection related since sqlite will still

Re: [sqlite] Getting SQLITE_BUSY within a transactionandhow tohandle it

2009-03-18 Thread Dennis Volodomanov
> I'm wondering on which statement your first thread returns busy as > well. both are waiting to get a transaction acquired? Or is the first > thread waiting for the commit? Both are waiting to start a transaction. > Maybe you can post some code or a little extraction of what you are > doing?