I'm trying to generate a schema export from the CaveatEmptor book example for Oracle 10g XE (express edition). But it doesn't work:
org.hibernate.MappingException: Dialect does not support identity key generation
at org.hibernate.dialect.Dialect.getIdentityColumnString(Dialect.java:548)
at org.hibernate.dialect.Dialect.getIdentityColumnString(Dialect.java:538)
at org.hibernate.mapping.Table.sqlCreateString(Table.java:389)

The dialect I'm using is org.hibernate.dialect.Oracle10gDialect.
My current workaround is to export for Hyersonic and edit the exported code by hand accordingly. Are there any best practices to export schemas for oracle or is it possible at all?

TIA
Gernot

Don't use identity columns if the database doesn't support it...