Hello,

I'm setting up a project with HSQL in combination with Hibernate 3.
I would like to use a GUID as primary key for a couple of tables.

HSQL by default doesn't support a GUID as type.
Hibernate can do that through the <generator class="guid"/> tag.

Will this work like that ?
Who will generate the GUID ?
Is that Hibernate layer or is such a generation forwarded to the database ?
Any possible side effects or things to consider ?

What column type do I use in HSQL ? Long ?

Many thanks,

Geert