You are making several standalone connections to one database file. This is safe only when the database is on a CD and set as read-only. You should reduce the number of connections to 1. If the database (file) is not corrupted, it is probably because your application uses the DB in an atomic way and you are not using cached tables -- just consider it good luck.
Some information on different connection modes, written in two different langauages (Campbell's and mine), can be found in the help forum. http://sourceforge.net/forum/forum.php?thread_id=640842&forum_id=73674 Fred > But in the meantime, re. connection pool with 20 connections? If these > connections are to an HSQLDB server, they wouldn't be a problem, but if they > are standalone database connections, they definitely are THE problem. > > Your original message had: > > at org.hsqldb.jdbcConnection.openStandalone(jdbcConnection.java:926) It is jdbc:hsqldb:hypersonic/reptile _______________________________________________ hsqldb-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hsqldb-developers