I have generator named 'Hibernate_Sequence' in firebird. In all the mapping files I have generator defined as

<id name="id" type="int" column="id" unsaved-value="0">
<generator class="native"/>
</id>

I know using this configuration every row I insert into any table .. I will have id as number from 'Hibernate_Sequence' plus 1.

What I want to have is use seperate generator for each table. How to do it and what is mapping file ?

I aslo used

<generator class="native">
<param name="GEN_MAILING_ID">GEN_MAILING_ID</param>
</generator>

But still new entry gets id from Hibernate_Sequence.

Any directions/help appreciated.
--Anand




Hibernate version:2.1.7

Mapping documents:N/A

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:Firebird1.5

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt: