Another option is to use a JPA entity over a view.
ie: Create a view in your database and then write a JPA entity that references the view. Then all your entity manager functions work fine and you just need to manipulate a single entity.
I am doing it now and have not had any problems.
Cheers
Cameron
[Message sent by forum member 'cameronr' (cameronr)]
http://forums.java.net/jive/thread.jspa?messageID=205387