Re: [sqlite] Sqlite 3 Crash on OSX

--- 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 > >

Re: [sqlite] Tomcat crashes with SQLite

> 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

[sqlite] Tomcat crashes with SQLite

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.

RE: [sqlite] Age calculation on literal

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

Re: [sqlite] ALTER TABLE ADD COLUMN - strange behaviour....Mac OSX

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]

[sqlite] ALTER TABLE ADD COLUMN - strange behaviour....Mac OSX

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