On 9 Jun 2005, at 10:15, Puneet Kishor wrote:
My question is: could I set some kind of "trace" that tells me what is
going on with SQLite?
$dbh->trace(LEVEL);
Try a level of 2 first and go up from there.
__
This email has b
On Thursday 09 June 2005 7:15 am, Puneet Kishor wrote:
> I've been a reading a lot on the "database locked" problem, but still
> need guidance trying to locate the source of my problem.
>
> environment: DBI/DBD::SQLite (latest versions) with SQLite3 (3.2.1) on
> Mac OS X (10.3.9).
>
> I am trying t
Hi,
I'm not sure of your environment, but here's some tidbits that might
help:
If you app crashes mid-way (say due to a syntax error or an exception
popped), the db can remain locked.And... if you are doing webby
related work and calling sqlite and something crashes, the lock isn't
On Jun 9, 2005, at 9:35 AM, Jay Sprenkle wrote:
I'm not familar with the wrapper you're using, but don't you have a
commit without a matching begin?
The commit is in the "wrapper," not in the SQL. When making a database
connection, I specified to turn AutoCommit to OFF. Hence, I have to
exp
I'm not familar with the wrapper you're using, but don't you have a
commit without a matching begin? Did you establish a lock on the table
before
trying to update? Are you updating a table that you currently are reading from?
As in:
select * from t;
for each result
update t set field = blah;
next
I've been a reading a lot on the "database locked" problem, but still
need guidance trying to locate the source of my problem.
environment: DBI/DBD::SQLite (latest versions) with SQLite3 (3.2.1) on
Mac OS X (10.3.9).
I am trying to update a table via the web. The UPDATE in question is
the ve
6 matches
Mail list logo