Hi

I wonder how to create a cached table w/ hibernate

Hibernate usually generates the following for table creation:
CREATE TABLE EVENTS(UID BIGINT NOT NULL PRIMARY KEY,DATE TIMESTAMP,EVENTTITLE VARCHAR(255))

but then the syntax for creating cached table on HSQL should've been:
CREATE CACHED TABLE EVENTS(UID BIGINT NOT NULL PRIMARY KEY,DATE TIMESTAMP,EVENTTITLE VARCHAR(255))

The problem I have:
As you can see, there is only one difference: the word "cached." How to get Hibernate generate the table creation with the word "CACHED" in it?

Thanks
Kris

Hi,

I have exactly the same problem with Hibernate + HSQLDB. Does anyone have any idea for this?

Thanks

afaik someone have put a CacheHSQLDialect into the jira/wiki.

look for that.

OK, I've found it, thanks. Don't you plan to integrate it in a future version? I think it would be very useful.

One trick that I've used with HSQLDB is to edit the .script file after a proper shutdown and insert the CACHED keyword for the tables that I want to be of that type. Since the CREATE TABLE statements are at the top of the script file, this is pretty easy.

Hi,

Yes, it's also a possible way, but I prefer creating the schema from the Java file:

Configuration cfg = new Configuration()
.addClass(examples.example1.Book.class);
new SchemaExport(cfg).create(true,true);
//new SchemaUpdate(cfg).execute(true, true);

In my case I need to delete all tables first, that's why I do it this way. So this HSQLCachedTableDialect would be very useful.