File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes SEVERE: Duplicate entry '1' for key 'PRIMARY' Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "SEVERE: Duplicate entry Watch "SEVERE: Duplicate entry New topic
Author

SEVERE: Duplicate entry '1' for key 'PRIMARY'

shankhas sanyal
Ranch Hand

Joined: Jun 15, 2008
Posts: 45
hi all,
I am very new to hibernate and I am following a simple one to many example that I found on "Vaannila.com".

these are my tables :


my hibernate.cfg.xml



my HibernateUtil.java


this my student.java bean:



this my student.hbm.xml:


my phone.java bean




my phone.hbm.xml



my main method class:




my complete output:



can some please explain to me why i am getting a duplicate entry exception?

Thank You!!!
Shankha

I love this place!
shankhas sanyal
Ranch Hand

Joined: Jun 15, 2008
Posts: 45
i have fixed this....
apparently this application is trying to add multiple records of the same record to the join table
and since there are multiple entries to student id and phone id in the jointable this is what is causing the problem. How to fix this?

1. remove all foreign keys on the join table
2. alter the join table
3. remove the primary key
4. add a new primary key with auto increment
5. save the table
6. run the project and now it runs properly without any errors and it inserts perfectly into the tables
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: SEVERE: Duplicate entry '1' for key 'PRIMARY'