aspose file tools*
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 Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "SQL Result set mapping not working" Watch "SQL Result set mapping not working" New topic
Author

SQL Result set mapping not working

Derek West
Greenhorn

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: http://aspose.com/file-tools
 
subject: SQL Result set mapping not working
 
Similar Threads
problem with @FieldResult, mapping does not seem to work
@ColumnResult
Question of using SqlResultSetMapping
Native Queries
@SqlResultSetMapping