• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JPA @NamedNativeQuery and scalar results

 
Brian Smith
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to use a @NamedNativeQuery which return an intersect query.

Here is the mapping I was trying



Eventhough this query returns all the columns of a single table, its treated as scalar because of the intersect operator. Here is the exception I got



How can I map this query to a entity? Will something like this work? Also how do I handle the foreign key that is mapped (in bold)? Do I need to map the related entity in the resultSetMapping as well? When this resultset it returned will the entities be managed? Or will I have to merge them?


Here is the entity definition



Thanks!
[ September 26, 2007: Message edited by: Brian Smith ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic