On Sunday 08 August 2004 8:32 pm, Scott Leighton wrote:
>
>Solved! Just to close the loop on this for the benefit of any other
> DBD::SQLite users who may be trying to upgrade from v 0.31 to v 1.x.x.
> Watch out for cases where your former working code left unfinished SELECT
> statements since
On Sunday 08 August 2004 6:52 pm, Scott Leighton wrote:
> On Sunday 08 August 2004 6:26 pm, D. Richard Hipp wrote:
> > Scott Leighton wrote:
> >
> > Whenever you start a SELECT statement (by calling sqlite3_step()) but
> > have not finalized that statement (using sqlite3_finalize() or
> > sqlite3_r
On Sunday 08 August 2004 6:26 pm, D. Richard Hipp wrote:
> Scott Leighton wrote:
>
> Whenever you start a SELECT statement (by calling sqlite3_step()) but have
> not finalized that statement (using sqlite3_finalize() or sqlite3_reset())
> the statement is probably holding a lock on the table(s) tha
Scott Leighton wrote:
OK, I've located my problem. I think I need a better understanding of
the 'locking'. Looks like my commits are failing due to earlier statements
remaining 'in progress'.
What I don't understand is this 'database table is locked' stuff. This is a
single process (no threa
On Sunday 08 August 2004 3:53 pm, Scott Leighton wrote:
> On Sunday 08 August 2004 3:42 pm, D. Richard Hipp wrote:
> > You should start looking for problems. The -journal file should be
> > deleted the moment a transaction commits. In fact, transaction commit is
> > defined as the moment when the
On Sunday 08 August 2004 3:42 pm, D. Richard Hipp wrote:
>
> You should start looking for problems. The -journal file should be deleted
> the moment a transaction commits. In fact, transaction commit is defined
> as the moment when the journal file is deleted. If the journal is never
> deleted,
Scott Leighton wrote:
I have finally succeeded in getting DBD::SQLite v 1.02 compiled and installed
on my AMD64 and have therefore started working with SQLite3. After reading
the documentation about locking and concurrency here
http://www.sqlite.org/lockingv3.html I am left with the impression t
I have finally succeeded in getting DBD::SQLite v 1.02 compiled and installed
on my AMD64 and have therefore started working with SQLite3. After reading
the documentation about locking and concurrency here
http://www.sqlite.org/lockingv3.html I am left with the impression that the
life of the
8 matches
Mail list logo
