I am using Hibernate 2.1.1 with the Oracle 9i database.

What ID generation strategie do I have to set in the mapping file,
if I want to to use a

Oracle insert trigger for the primary key value generation of the pk column?

The Oracle insert trigger is fired every time, when a new record is inserted into
a table and fetches a new ID value from an Oracle sequence... (it's like a
AutoInc column in mySQL).

thx,
Juergen

Well, you might be able to use the identity generator, if you write your custom dialect. Just override getIdentitySelectString to return a SQL query which fetches the last generated value from the database.

If that is not possible, try looking at writing your own generator class.

Thx, your proposals seem easy to be implemented, but I am wondering,
why hibernate doesn't support this commonly used strategy for Oracle?

The source must already be available in hibernate, so I will have a look
at the source for the mySQL autoinc id support.

=> What is the easiest way for me to extend hibernate and supply
the sources for the next release of hibernate?

Implement it, submit a request/patch to JIRA, get people to vote for it. I told you the possible ways to implement it allready.