I am using PostgreSQL and Serial type for my sequence in my DB. But, when I try to insert a new object, the next exception is showed:

org.postgresql.util.PSQLException: ERROR: relation "hibernate_sequence" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:75)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:91)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:186)
at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:175)
at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:530)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:518)
at org.hibernate.impl.SessionImpl.save(SessionImpl.java:514)
at pojo.base._BaseRootDAO.save(_BaseRootDAO.java:629)
at pojo.base._BaseRootDAO$1.run(_BaseRootDAO.java:618)
at pojo.base._BaseRootDAO.run(_BaseRootDAO.java:755)
at pojo.base._BaseRootDAO.save(_BaseRootDAO.java:615)
at pojo.base.BaseProjectDAO.save(BaseProjectDAO.java:109)
at Test.main(Test.java:36)


The syntax of my hbm is like that:

<generator class="sequence"/>

Any ideas?

You should use the PostgreSQL syntax:

<generator class="sequence">
<param name="sequence">name_of_sequence</param>
</generator>

Regards

it runs!, many thanks.

Best regards.