From: | "xuemei" <xgan(at)ubitech(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Postgresql with Hibernate issues |
Date: | 2006-05-25 16:09:22 |
Message-ID: | 20060524154615.2C92E9F9F8F@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello:
I have a java application that starts several processes to retrieve data and
store them into the database tables;
When I run this on winXP and with Hibernate/Mysql, everything looks ok.
Now I need to use postgresql, so I change the hibernate configuration file.
When I run the program, the tables are created and records inserted into
several tables.
But the ID for each table are all wrong.
A closer look indicates that the hibernate is using the select nextval for
each insert command, which results in the
ID for each table is considered as a global one,
Tables ID
table1 1 , 5
table2 2,3,4
table3 6
table4 7,8
table1 9 ,10
Why this is happening, does this mean Hibernate with postgresql can not
work?, whileas same application+ Hibernate with mysql
Works perfectly fine?
Thanks a lot for your advices.
Shemy
From | Date | Subject | |
---|---|---|---|
Next Message | Florian G. Pflug | 2006-05-25 16:49:14 | Re: background triggers? |
Previous Message | Bill Moran | 2006-05-25 15:25:23 | Re: Postmaster crashes after upgrade to 8.1.4! |