Re: [sqlite] Locking with auto-commit disabled

2006-02-01 Thread Jay Sprenkle
> Hello, > I have a question regarding sqlite's behavior when auto commit is disabled. > > I have two conflicting transactions, A & B, where A is started first. > B starts by executing some SELECT queries (which all succeed), then on > the first UPDATE I get SQLITE_BUSY (as A is holding a conflicti

[sqlite] Locking with auto-commit disabled

2006-02-01 Thread gammal . sqlite
Hello, I have a question regarding sqlite's behavior when auto commit is disabled. I have two conflicting transactions, A & B, where A is started first. B starts by executing some SELECT queries (which all succeed), then on the first UPDATE I get SQLITE_BUSY (as A is holding a conflicting lock). I