JPA/Eclipselink - Multpile entities in single table

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