Hibernate version: 2.1.6

Hsqldb : 1.7.2

I must be missing something. SchemaUpdate appears only to be able to generate ddl for memory based tables in Hsqldb. Is there an option somewhere that would force creation of persistent tables, ie. "create cached table foo ..."?

Memory based tables are the default and are only appropriate for small tables. I love the portability of SchemaUpdate and would hate to have to write scripts for each potential dbms used by our app. Has anyone else experienced this limitation?

Thx

There were significant changes in HSQDB in 1.7.2 where the tools were supporting earlier version(s). Help out and write a dialect for the latest version and submit to JIRA.

Unfortunately, as far as I can tell, it's not a matter of writing a new dialect. SchemaUpdate calls Table.sqlCreateString() which prepends the phrase "create table" regardless of dialect.

Any suggestions?

I have not looked into SchemaUpdate's code for quite some time. I'd imaging it's easy to add an extra Dialect overrideable call in this location then the base dialect include the call (empty string) and appropriate (new) hsq dialect override with the approrpriate string.