Paste into JPA collection without loading

Question

I am currently using such code to add a new record to a set in my entity.

player = em.find(Player.class, playerId); player.getAvatarAttributeOwnership().add(new AvatarAttributeOwnership(...)); 

It works, but every time I want to add one item, the whole set loads.

• Is there a way (possibly with a request) to add an item without loading the rest? In SQL, it will be something like INSERT INTO AvatarAttributeOwnership(player, data, ...) VALUES({player}, ...);
• Uniqueness is currently maintained by the Set and AvatarAttributeOwnership.equals , but I assume this will not work anymore. How can I enforce it anyway?

I am using JPA2 + Hibernate. The code:

 @Entity public class Player implements Serializable { @Id @GeneratedValue private long id; @ElementCollection(fetch=FetchType.LAZY) // EDIT: answer to #2 @CollectionTable( uniqueConstraints=@UniqueConstraint (columnNames={"Player_id","gender","type","attrId"})) Set<AvatarAttributeOwnership> ownedAvatarAttributes; ... } @Embeddable public class AvatarAttributeOwnership implements Serializable { @Column(nullable=false,length=6) @Enumerated(EnumType.STRING) private Gender gender; @Column(nullable=false,length=20) private String type; @Column(nullable=false,length=50) private String attrId; @Column(nullable=false) private Date since; @Override public boolean equals(Object obj) { if (this == obj) return true; if (obj == null) return false; if (getClass() != obj.getClass()) return false; AvatarAttributeOwnership other = (AvatarAttributeOwnership) obj; if (!attrId.equals(other.attrId)) return false; if (gender != other.gender) return false; if (!type.equals(other.type)) return false; return true; } ... } 

Answer 1

Try large collections :

 @LazyCollection(LazyCollectionOption.EXTRA)