Re: [sqlite] Tomcat crashes with SQLite
I am just trying the last version of http://www.ch-werner.de/javasqlite/ date: June 26th 2007 Lucy will see if she is ok now... http://lucy.ysalaya.org Cheers Frederic de la Goublaye On 6/25/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Frederic de la Goublaye" <[EMAIL PROTECTED]> wrote: > My server is under FreeBSD 5.4 > It is ok ? > I am not aware of any problems with FreeBSD 5.4. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Tomcat crashes with SQLite
"Frederic de la Goublaye" <[EMAIL PROTECTED]> wrote: > My server is under FreeBSD 5.4 > It is ok ? > I am not aware of any problems with FreeBSD 5.4. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Tomcat crashes with SQLite
My server is under FreeBSD 5.4 It is ok ? Cheers Frederic On 6/25/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Frederic de la Goublaye" <[EMAIL PROTECTED]> wrote: > 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. > Some version so of Linux have a bug. Upgrade to linux kernel series 2.6 and you should be OK. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Tomcat crashes with SQLite
"Frederic de la Goublaye" <[EMAIL PROTECTED]> wrote: > 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. > Some version so of Linux have a bug. Upgrade to linux kernel series 2.6 and you should be OK. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Tomcat crashes with SQLite
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] > > - > >
Re: [sqlite] Tomcat crashes with SQLite
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] -
Re: [sqlite] Tomcat crashes with SQLite
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] -
Re: [sqlite] Tomcat crashes with SQLite
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] -
Re: [sqlite] Tomcat crashes with SQLite
Hi all.
Lucy thanks for your answer :+)
http://lucy.ysalaya.org
My issue is not closed because the site crashes these days.
I do not think I use the same connection in different threads at the same
time.
I am still using the javasqlite ODBC driver.
But I did not but the jdbc into the Tomcat server.xml file.
As I did for MySQL because as far as know, the jdbc needs the path to the
database file
and under my project, all the chatbot databases are different
/user_idr/bot_base_type.db
Here is my source code for the Java class connection.
Maybe you can have a look (it is simple, maybe too much)
_
Copyright 2006-2007 Frederic de la Goublaye
_
public class SQLite {
private static Logger logger = Logger.getLogger(SQLite.class.getName());
private final static String pilote = " SQLite.JDBCDriver";
private Connection con = null;
private PreparedStatement s;
private static SQLite instance = new SQLite();
public static SQLite getInstance() {return instance;}
private static String sDBPath;
private SQLite() {
try {
Class.forName(pilote);
con = null;
s = null;
} catch (Exception e) {
logger.error(e.getMessage());
}
}
public String getDBPath() {return sDBPath;}
public void setDBPath(String pDBPath) {sDBPath= pDBPath;}
public void connection(String pDBPath) {
try {
sDBPath = pDBPath;
con = DriverManager.getConnection(sDBPath);
con.setAutoCommit ( true );
}
catch (SQLException e) {
logger.error(e.getMessage());
logger.error("sDBPath="+sDBPath);
if (con != null) {
try {
con.close();
} catch (Exception ex) {
logger.error(ex.getMessage());
}
finally {
con = null;
}
}
}
}
public void deconnection() {
if (s != null) {
try {
s.close();
} catch (Exception e) {
logger.error(e.getMessage());
}
finally {
s = null;
}
}
if (con != null) {
try {
con.close();
} catch (Exception e) {
logger.error(e.getMessage());
}
finally {
con = null;
}
}
}
public ResultSet execQuery(String pRequest) {
try
{
s = con.prepareStatement(pRequest);
ResultSet rset = s.executeQuery();
return rset;
}
catch(SQLException e) {
logger.error(e.getMessage());
logger.error("sSql="+pRequest);
if (s != null) {
try {
s.close();
} catch (Exception ex) {
logger.error(ex.getMessage());
}
finally {
s = null;
}
}
return null;
}
}
public void finalize() {
try {
deconnection();
}
catch (Exception e) {
logger.error(e.getMessage());
}
}
public String getStringForSQL(String str) {
StringBuffer sb = new StringBuffer(255);
if (str == null) return str;
char[] cc = str.toCharArray();
for (char i = 0; i < cc.length; i++) {
if (cc[i] == '\'') {
sb.append('\\');
} else if (cc[i] == '\\') {
sb.append('\\');
}
sb.append(cc[i]);
}
return sb.toString();
}
}
_
Thanks again for your attention.
Frederic de la Goublaye
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]
-
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 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] -
