Meaningless Drivel is fun!
The moose likes Object Relational Mapping and the fly likes SQL Result set mapping not working Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "SQL Result set mapping not working" Watch "SQL Result set mapping not working" New topic

SQL Result set mapping not working

Derek West

Joined: Jun 18, 2012
Posts: 9
Hello there. I can't seem to get my SqlResultSetMapping to work in openJPA...
I have a named native query...

I then have this @SqlResultSetMapping for the following Entity Bean...

For the life of me, I can't get the parentOrganizationID to map to anything...
For instance, if I change the column and or name of any of the fieldsets, I get THE EXACT SAME RESULT!!!
Which is the most frustrating thing... Which tells me that I somehow the SqlResultSetMapping does not seem to be
affecting anything. Can any one help...
Oh, here is how I call the query...

It would seem as though underscores are not being displayed on this forum. I will edit it so that I will have a "-" instead of an underscore...
I agree. Here's the link:
subject: SQL Result set mapping not working
It's not a secret anymore!