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 ]