Hi,

I have suddently a serious crash of my production machine because of out of memory on HSQLDB. It is the same probleme on test machine (one day after).

Here is the error message from stdout log :
ERROR [JDBCExceptionReporter] out of memory

My hibernate.data size is about 32 Mo on test and 260 Mo on prod, so I read it is usefull to migrate to a MySQL database.

But now (without migration) do you know please if I can quickly solve the problem on production machine with HSQLDB ?

See more informations below, I use BI server 3.5.2.

Apache Tomcat Java Options :
-Xms512m
-Xmx1024m
-XX:MaxPermSize=512m

hibernate properties :
hsqldb.default_table_type=cached

start_hypersonic.bat :
-Xms512m -Xmx1024m -XX:MaxPermSize=512m -cp

Thanks for your help, I don't know if there is an other forum for that.