My server crashed again. I recompiled sqlite3-3-5 with this configure option --enable-threadsafe =yes
But I read that sqlite has somebug under Unix with the management of the THREADS. Can it work with my Java code ? Thanks for attention. Frederic An unexpected exception has been detected in native code outside the VM. Unexpected Signal : 10 occurred at PC=0x712C5D06 Function=sqlite3VdbeExec+0x24D2 Library=/usr/local/lib/libsqlite3.so.8 On 6/24/07, Frederic de la Goublaye <[EMAIL PROTECTED]> wrote:
Thanks for your answer. I just recompiled sqlite with *DTHREADSAFE=1* http://www.sqlite.org/cvstrac/wiki?p=MultiThreading I will publish the results. Cheers Frédéric On 6/22/07, Russell Leighton <[EMAIL PROTECTED]> wrote: > > > If you did not compile sqlite as multi-threaded this is exactly what > would happen. > > On Jun 22, 2007, at 9:06 PM, Frederic de la Goublaye wrote: > > > Hi I just tried this driver: > > http://www.zentus.com/sqlitejdbc/ > > > > The result is ten times slower or even more. > > Maybe I am wrong using this new driver. > > > > So for the moment I am still using this one: > > http://www.ch-werner.de/javasqlite/ > > > > BUT I HAVE STILL THE CRASH TROUBLES: > > > > An unexpected exception has been detected in native code outside the > > VM. > > Unexpected Signal : 11 occurred at PC=0x34D8493F > > Function=sqlite3VdbeExec+0x10B > > Library=/usr/local/lib/libsqlite3.so.8 > > > > ANY IDEAR ??? > > > > Thanks for your attention. > > > > Cheers > > Frederic > > > > > > > > > > > > On 6/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> > > wrote: > >> > >> > >> > 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. > >> > It seems to be an error in SQLite outsite the Java Virtual Machine. > >> > > >> > ANY IDEAR ? > >> > >> I see 2 possible explanations: > >> 1. You use the same connection in different threads at the same time. > >> 2. There are bugs in JDBC driver. If this is the case, try driver > from > >> http://www.zentus.com/sqlitejdbc. It for sure has bugs, but may be > >> different and you won't even notice them. You may use pure java > >> version - > >> it will be probably slower than JNI based, but should never crash VM. > > >> > >> > >> > >> > ---------------------------------------------------------------------- > >> Wicie, rozumicie.... > >> Zobacz >>> http://link.interia.pl/f1a74 > >> > >> > >> > >> > ---------------------------------------------------------------------- > >> ------- > >> To unsubscribe, send email to [EMAIL PROTECTED] > >> > >> > ---------------------------------------------------------------------- > >> ------- > >> > >> > > > ----------------------------------------------------------------------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > >
