> John Firebaugh wrote: > > I take it this mean that if, say, thread A begins a transaction, and > > modifies the database, then thread B modifies the database, > then thread > > A commits the transactions, B's modifications are also committed? > > Nope. Once thread A begins a transaction, no other thread > (or process) > can modify the database until thread A commits. (That's what "atomic > transaction" means!) > > In the above scenario, thread B will likely get a SQLITE_BUSY when he > tries to UPDATE. He should sleep for awhile and try again.
To clarify, that's the behavior in the case where each thread has its own database connection. But I'm referring to the case where the threads are sharing a single connection. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------