There is no direct call to the sqlite jdbc driver (org.sqlite.* classes) in the stack trace. It seems to be a problem in the use of org.apache.commons, not sqlitejdbc. Try the apache mailing list for this library.
I've had no issues with 2 JVM processes sharing a single database on Linux with java 1.5. Just write a standalone program using only the standard JRE jdbc calls and the sqlitejdbc jar file with no other libraries to verify this for yourself. --- hiroko <[EMAIL PROTECTED]> wrote: > -platform > Linux 2.4.21-32.0.1.ELsmp i686 i686 i386 GNU/Linux > > -jvm 1.5.0_11 > > We are using jakarta org.apache.commons.dbcp package for connection > pooling (although at this point our programs are single-threaded, > using one connection at a time), so I should first ask if sqlite is > supposed to work with the package. It hangs when it tries to get > connection from the pool. Here is the stack trace of the hung > process: > > "main" prio=1 tid=0x0805c960 nid=0x2024 in Object.wait() > [0xbfffb000..0xbfffbab8] > at java.lang.Object.wait(Native Method) > - waiting on <0x727271f8> (a > org.apache.commons.pool.impl.GenericObjectPool) > at java.lang.Object.wait(Object.java:474) > at > org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java: > 810) > - locked <0x727271f8> (a > org.apache.commons.pool.impl.GenericObjectPool) > at > org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java: > 95) > at > com.thomson.research.db.ConnectionPool.getConnection(ConnectionPool.java: > 90) > at > com.thomson.fermi.infodmal.SqliteJDBC.readDocumentObj(SqliteJDBC.java: > 191) > at > com.thomson.fermi.infodmal.CacheManager.getDocumentFromDB(CacheManager.java: > 84) > > The same programs work without any problem when I run them > sequentially. > > Thanks, > Hiroko __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
