[sqlite] END TRANSACTION failed with "database is locked"

2008-10-08 Thread Manoj Marathayil
Hi, I am executing some operations in a loop and all the operations are wrapped inside a transaction. During one iteration the "END TRANSACTION" returned with an error "database is locked". Since this is in a loop my next request to "BEGIN TRASACTION" failed with "cannot start a transaction within

Re: [sqlite] END TRANSACTION failed with "database is locked"

2008-10-08 Thread Alexandre Courbot
> I am executing some operations in a loop and all the operations are wrapped > inside a transaction. During one iteration the "END TRANSACTION" returned > with an error "database is locked". Since this is in a loop my next request > to "BEGIN TRASACTION" failed with "cannot start a transaction wit

Re: [sqlite] END TRANSACTION failed with "database is locked"

2008-10-08 Thread Ken
abase you should finalize or if your unlikely to need the statement in a while then finalize. HTH Ken --- On Wed, 10/8/08, Manoj Marathayil <[EMAIL PROTECTED]> wrote: From: Manoj Marathayil <[EMAIL PROTECTED]> Subject: [sqlite] END TRANSACTION failed with "database is locked&q

Re: [sqlite] END TRANSACTION failed with "database is locked"

2008-10-08 Thread Manoj M
2. Re: END TRANSACTION failed with "database is locked" > (Alexandre Courbot) > 3. Re: END TRANSACTION failed with "database is locked" (Ken) > 4. Re: Record locking (Ken) > > > --------------------------

Re: [sqlite] END TRANSACTION failed with "database is locked"

2008-10-09 Thread Manoj M
2. Re: END TRANSACTION failed with "database is locked" > (Alexandre Courbot) > 3. Re: END TRANSACTION failed with "database is locked" (Ken) > 4. Re: Record locking (Ken) > > > --------------------------