Im using hibernate 3.2 with postgresql 8.1.

I have an Employee class, and I am trying to save the very first employee to the table

session = factory.openSession();
session.beginTransaction();
session.save(this);
session.getTransaction().commit();

I get this error:

Hibernate: select nextval ('hibernate_sequence')
org.hibernate.exception.SQLGrammarException: could not get next sequence value
...
Caused by: org.postgresql.util.PSQLException: ERROR: relation "hibernate_sequence" does not exist

I created the table by hand like this:
create table employee (id serial primary key, lastName varchar(40), firstName varchar(40));

Do I somehow need to create the schema from hibernate?

I appreciate any suggestions!

Mapping documents:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="com.schumeyer.trust.Employee" table="EMPLOYEE">
<id name="id" column="id">
<generator class="native" />
</id>
<property name="lastName" />
<property name="firstName" />
</class>
</hibernate-mapping>

Since you are using the "Native" Generator for the generation of your primary key hibernate tries to load the id from a sequence called hibernate_sequence.

Basically you have two options:
- if you don't want to use hibernate_sequence you have to look for a different id generator. This is documented here:
http://www.hibernate.org/hib_docs/v3/re ... aration-id

- The easiest solution for you would be to create the hibernate_sequence in Postgres like that:

After some digging, I changed the mapping to add the param element. This seems to work.

<class name="com.schumeyer.trust.Employee" table="EMPLOYEE">
<id name="id" type="integer" column="id">
<generator class="native">
<param name="sequence">employee_id_seq</param>
</generator>
</id>
<property name="lastName" />
<property name="firstName" />
</class>