jQuery in Action, 3rd edition
The moose likes Object Relational Mapping and the fly likes hibernate mapping xml issue. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "hibernate mapping xml issue." Watch "hibernate mapping xml issue." New topic

hibernate mapping xml issue.

mano ranjan
Ranch Hand

Joined: Jul 12, 2007
Posts: 102
I have table which does not have a primary key .The hbm xml is showing error without primary key.so is there any other way to map the xml without primary key ..

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Hibernate is an object-relational mapping tool. Data without a primary key is not relational. The problem is that without an id to uniquely identify a row there is no way this data can partake in a relationship. So Hibernate cannot support it.

What you should do is add a surrogate key to your table. If you can't do this, you can map the entire table as a composite key, though this will only work if your table doesn't include duplicate data. If neither of these are possible, don't map the table and handle it in bespoke manner via JDBC (which shouldn't be too disruptive if your persistance code uses a pattern like DAO).

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link: http://aspose.com/file-tools
subject: hibernate mapping xml issue.
It's not a secret anymore!