• Post Reply Bookmark Topic Watch Topic
  • New Topic

JPA @NamedNativeQuery and scalar results  RSS feed

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

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