Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0

Name and version of the database you are using:PostgreSQL 8.0

Hi,

I am using Hibernate with postgreSQL 8.0. I can read the data from my Database and also update existing records fine but when I try to insert the save fails on the generator. I have the database tables mapped as follows :



However I have also tried native, increment and hilo, none of which seems to work.

I know there are people out there using Hibernate and postgreSQL so am hoping I am just missing something. The field is a serial field in the database.

Thanks
Connie

Not sure what the error is as you did not supply it.
Having said the the obvious first thing is to check that you have created the sequence in the database. I would normally name a sequence when using the sequence (or native on a db using sequences) - to do that see docs. If it is not named it assumes you have a general sequence defined in the database - its name is 'hibernate_sequence'.

Hi,


The error I am getting now is

Sessionworkplanner.hibernate.workplanner.dto.SessionToken@275
Hibernate: select nextval ('sessiontoken_sessiontokenid_seq')
Hibernate: insert into sessiontoken (userid, wamikey, session_id, logon_dt_tm, sessiontokenid) values (?, ?, ?, ?, ?)
net.sf.hibernate.JDBCException: Could not execute JDBC batch updateaccess workplanner.security.Access@29a046

If I have already created a record I can edit it to my hearts content. But any attempt to insert a record causes a failure and no data is saved.

I recreated the sequences and gave each table its own sequence, calling them individually in the mapping files but to no avail.

I use Informix at work and it works fine but I need to work on it at home and I only have postgreSQL at home. So I have rewritten all mappings and config file but I cannot insert a record.