开发者

How to add a Map<String, Person> in an entity class?

I want to add a mapping as

Map<String, Person> personMap;

inside an entity class, where Person is the entity. The Map is to identify the exact Person corresponding to the String (let it be a nickname of开发者_高级运维 that person). The same person may have different names and whenever any of the names is given, the same Person has to be found.

Persistance API used is JPA and the provider is EclipseLink. What annotation should I use and how?


As per section 2.7 of JSR-317, if the value of the Map is an entity (which is your case) a join table is created and then a OneToMany / ManyToOne annotation should be used.

As for the key, if it is a Basic Type, the @MapKeyColumn can be used to customize the mapping column of the key. So here is my take on your example:

@OneToMany
@MapKeyColumn(name="person_nickname")
Map<String, Person> personMap;

EDITED:

After some testing, the following seems to work pretty well:

@ElementCollection
@CollectionTable(name="<name_of_join_table>")
@MapKeyColumn(name="<name_of_map_key_in_table>")
Map<String, Person> personMap;

The above generates a join table with three fields: one for the mapping holder id, one for the key and one for the value.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜