Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.1

Name and version of the database you are using:
HSQL db -7.1.2


Hi all,
I am using HSQLdb 7.1.2 version and I want to create cached tables in HSQL database. In my application I am using XDoclet for all mapping file creation and using hibernate.util.Schemaexport utility to create the database schema. So by default it creates in-memory tables in HSQL, how can I configure hibernate so that it creates cached tables in hsql?

Thanks in advance,
Mithun Kulkarni

You cant, here http://opensource2.atlassian.com/projec ... se/HB-1398
you can found a patch that somebody post to fix this problem.

If you use hsqldb 1.8.0 you can select the default table by setting the property: "hsqldb.default_table_type" to [cached|memory]. The property being set by using a sql statement or extending the connection url.



Please rate

Check this class, it seems that generates the apropiate cached tables

http://opensource2.atlassian.com/projec ... alect.java

Please rate