I use a native generator with postgres.
My problem: Adding an entry manually to the database and increasing the sequence throws an ConstraintViolationException: (duplicate key violates unique constraint) while the SessionFactory is open calling session.saveObject(o).

It seems like Hibernate doesn't update the sequence count internally. Is there any setting? or mapping property to keep it synchron ?

Tearing down "SessionFactory.close()" and "buildSessionFactory" again gets the right sequence count..


Hibernate version:
Hibernate 3.0.5

Mapping documents:
<generator class="native">
<param name="sequence">my_sequence</param>
</generator>

I had problems with native generator and postgres too. try class="sequence" instead of class="native".

Hope that helps

Kolja

I use Postgres 8.0
The following class fragment works very good for me:

<id name="id" type="java.lang.Long" unsaved-value="null">
<column name="`ID`" sql-type="BIGINT"/>
<generator class="native">
</generator>
</id>

SchemaExport will create something like hibernate_sequence at the database.