开发者

JPA/Eclipselink - Multpile entities in single table

开发者 https://www.devze.com 2023-04-12 22:38 出处:网络
I\'m using Eclipselink to map my t开发者_运维问答ables to entities. I have one big database table (actually it\'s view) with columns like groupId, groupName, categoryId, categoryName etc. I know it\'s

I'm using Eclipselink to map my t开发者_运维问答ables to entities. I have one big database table (actually it's view) with columns like groupId, groupName, categoryId, categoryName etc. I know it's redundand, but we're trying to minimize queries and it's dynamically created view.

The question is: How to map such table to several entities like Group, Category etc?


You would probably be better off mapping to the real tables and use query optimization to reduce your queries (such as join fetching and batch fetching)

See, http://java-persistence-performance.blogspot.com/2010/08/batch-fetching-optimizing-object-graph.html

If you really want to have several class map to the same table, you will need to have one Entity and make the rest Embeddables.

See, http://en.wikibooks.org/wiki/Java_Persistence/Embeddables

0

精彩评论

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

关注公众号