Java – HSQLDB sqlexception: establish database connection in memory

We have a desktop application with a local HSQLDB database Some customers report that their applications stop working When I try to open it with dbvisualizer, I can see this in the debugging console:

12:45:32 [DEBUG pool-2-thread-1 D.?] RootConnection:     jdbcDriver.connect("jdbc:hsqldb:C:\test\database.db",{user=**,password=})
java.sql.sqlException: error in script file line: 56 out of memory
    at org.hsqldb.jdbc.Util.sqlException(UnkNown Source)
    at org.hsqldb.jdbc.jdbcConnection.<init>(UnkNown Source)
    at org.hsqldb.jdbcDriver.getConnection(UnkNown Source)
    at org.hsqldb.jdbcDriver.connect(UnkNown Source)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(UnkNown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(UnkNown Source)
    at java.lang.reflect.Method.invoke(UnkNown Source)
    at com.onseven.dbvis.d.B.D.?(Z:1548)
    at com.onseven.dbvis.d.B.F$A.call(Z:278)
    at java.util.concurrent.FutureTask$Sync.innerRun(UnkNown Source)
    at java.util.concurrent.FutureTask.run(UnkNown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(UnkNown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(UnkNown Source)
    at java.lang.Thread.run(UnkNown Source)

Anyone knows what to do to open it and analyze the problem?

Solution

This exception usually occurs when the database is corrupted Try using a backup of the database For another discussion on this topic, see here