File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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!