Folks.
I had been struggling to implement ALTER TABLE ADD COLUMN in my app
to change the database structure. However I would continuously face a
locked database error.
After much experimentation I have come to a very very strange conclusion.
In my app if I do this:
-start app
-open
On 6/3/07, Mark Gilbert [EMAIL PROTECTED] wrote:
Anyone have *any* idea what is happening ?
I don't know nothing about MacOS, but you may want to check the result
of sqlite3_close. It's possible it's not closing the database [1].
Regards,
~Nuno Lucas
[1]
This function works and despite the convoluted construction it is pretty
fast, takes about 0.5 sec to convert one field in about 25000 rows.
I thought I can speed it up by replacing all the SQLite functions that
produce a literal by a VB variable. Indeed with this I can get it down to
about 0.3
Hi All
My project is working with Tomcat, SQLite and javasqlite.
http://www.ch-werner.de/javasqlite/
http://www.ysalaya.org
Since a few weeks Tomcat server crashes very often: error 505
and I need to restart it manually. It is installed on FreeBSD 5.4.
Please see the Tomcat log file bellow.
My project is working with Tomcat, SQLite and javasqlite.
http://www.ch-werner.de/javasqlite/
http://www.ysalaya.org
Since a few weeks Tomcat server crashes very often: error 505
and I need to restart it manually. It is installed on FreeBSD 5.4.
Please see the Tomcat log file bellow.
--- Dan Kennedy [EMAIL PROTECTED] wrote:
On Fri, 2007-06-01 at 10:51 +0100, Mark Gilbert wrote:
Folks.
My app just crashed in the field randomly after some time running fine.
Thread 12 Crashed:
0 libsqlite3.0.dylib 0x9406e587 sqlite3pager_get + 390
1