How to add primary key column in existing table for hibernate WITHOUT actually adding column to it

Question

I am using Spring+HibernateDAO and want to access a table which does not have a primary key. Because Hibernate requires that entity tables have primary keys. ,I need to create some virtual primary key(perhaps), just to fool hibernate (it satisfies with @Id only) Or doing any efforts on database side without touching existing table is also fine. Please suggest any workaround which does NOT require ALTER EXISTING TABLE , any other table inheritance/structure changes are welcome.

PS. Already using JDBC template with manual mapping of columns to custom object.DB is Sybase ASE15 if it matters.

Have you looked at composite primary keys with hibernate? Hopefully there are a set of columns that are unique. If so map those as a composite key. — neildo
– neildo, Commented Feb 5, 2014 at 5:44
@neildo Yes I already tried considering that, but because of type of data in the table and manner its already being used can not use it. — Sankalp
– Sankalp, Commented Feb 5, 2014 at 6:15
If you ONLY want to use Hibernate to SELECT from this table, you could use a native query to populate a non-managed entity: docs.jboss.org/hibernate/core/3.3/reference/en/html/… If you want Hibernte to manage INSERT/UPDATE/DELETE then you are out of luck. You must have an ID. Identity is a core aspect of Hibernate's entity management. — neildo
– neildo, Commented Feb 5, 2014 at 6:56
Yes you are right @neildo . As my requirement dont include Updates this Idea works for some extent. The reason for only some extent is like :- q.setResultTransformer(Transformers.aliasToBean(Y.class)); but this fails with: org.hibernate.PropertyNotFoundException: Could not find setter for some_property. X has a field called someProperty with the appropriate getter and setter but in this case it doesn't seem like Hibernate maps the column name (some_property) to the correct field name. Agree its a good idea but ,I will let the question still open as perhaps we may get more featured solution. — Sankalp
– Sankalp, Commented Feb 5, 2014 at 9:45

Community · Accepted Answer · 2017-05-23 12:11:45Z

1

There are some many answers to your question on stack-overflow itself, I am surprised, you didn't find one :P

How to work with tables without PRIMARY KEY in Hibernate?

Hibernate and no PK

Hibernate without Primary Key

This one on CodeRanch

Analyse and make your choice :)

edited May 23, 2017 at 12:11

CommunityBot

11 silver badge

answered Feb 5, 2014 at 11:01

DarkHorse

2,77021 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sankalp Over a year ago

@DarkHorrse Yes the solution 'Hibernate and no PK' works. Actually I just read it too literraly which was mentioned in your third reference earlier ` Hibernate requires that entity tables have primary keys. End of story. ` But you have got the correct way there in Second Solution. Tons of thanks :)

Collectives™ on Stack Overflow

How to add primary key column in existing table for hibernate WITHOUT actually adding column to it

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related