I have object table and object_id_seq table.
Mapping works fine until I need to add new one to database. Then I need to use id from object_id_seq and that's the problem.
How can I configure mapping to use id from object_id_seq table when new object is created?
And object_id_seq table always have one row and one column which is id. Can hibernate support such sequence table using mapping xml or I need to use SQL?

This suggested configuration doesn't fit the case because it uses db sequence feature;
<class name="Object" table="object">
<id
column="id"
name="id"
type="java.lang.Long"
>
<generator class="sequence">
<param name="sequence">object_id_seq</param>
</generator>
</id>

Do I need to create separate mapping for sequence table and then manually update it or it can be done with mapping config?

Write a custom generator. Take HiLoGenerator as a model.

If the database is firebird, I can have seperate generator for each table. Can I configure hibernate to use it ?

--Anand

sure

Isn't my solution to use HiLo generator?
I am trying to understand what kind of generator I need to write and it seems that HiLo does exactly what I need.
Or I am missing something?