How to specify a Primary Key on @ElementCollection

java hibernate jpa orm hibernate-mapping
plcstpierre picture plcstpierre · May 5, 2015 · Viewed 7.2k times · Source

So, there is that behavior with innodb that can cause problem if some tables lack of primary key.

So with Hibernate, I am looking for a key to specifies a primary key on a @ElementCollection table with a Set as the underling data structure.

I found a way to have a primary key with a map, but it is kind of weird because I do not need a map.

I also found an answer related to @Embeddable, but I do not need that kind of complexities. I am using a Set or Set as the data structure in my entities.

Any idea how to achieve that?

Answer

Dave L. picture Dave L. · Nov 20, 2015

If you use a Set and make the element Column be not null, then hibernate will make a primary key with the join column and element column.

Example:

@Column(name = "STRINGS", nullable = false)
@ElementCollection
private Set<String> strings;

Related questions

How to map calculated properties with JPA and Hibernate

My Java bean has a childCount property. This property is not mapped to a database column. Instead, it should be calculated by the database with a COUNT() function operating on the join of my Java bean and its children. It …

Read More
Hibernate throws strange error: Class is not mapped

this is the error org.hibernate.hql.ast.QuerySyntaxException: Payment is not mapped [select p from Payment p] I don't understand how come this error is thrown, the class should be mapped as I will show you briefly. I have …

Read More
Delete child from parent and parent from child automatically with JPA annotations

Suppose that we have 3 Entities object class: class Parent { String name; List<Child> children; } class Child { String name; Parent parent; } class Toy { String name; Child child; } How can I use JPA2.x (or hibernate) annotations to: Delete all …

Read More