wood burning stoves*
The moose likes Object Relational Mapping and the fly likes JPA and mapping result sets to POJO:s Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "JPA and mapping result sets to POJO:s" Watch "JPA and mapping result sets to POJO:s" New topic
Author

JPA and mapping result sets to POJO:s

E Erik Svensson
Greenhorn

Joined: Nov 08, 2010
Posts: 4
Howdy all!

I have a couple of sp:s I'm calling and a few returns a result set when things go wrong. I'm trying to map those to POJO:s but it's not going well.

My NamedNativeQueries:


The InserLeaseError class:


And the code that ties it all together:


I'm running Hibernate 3.5.5 as persistence provider and I get these errors:



I was surprised that you can use TypedQueries for native queries (the 'getFreeIds' named query works perfectly).

Googling around I've found a few uses cases where the result set is mapped on pojos but there are not much detail.
The Pro JPA2 book by Mike Keith doesn't seemt to address the problem at all.
Thankful for any help here

cheers
Erik
E Erik Svensson
Greenhorn

Joined: Nov 08, 2010
Posts: 4
I found it myself.
The class that maps the result set needs to be an Entity.
It also needs an id. My problem was then that the rows of the result set were not guaranteed to be unique so I had to add the row index to the result set.
Then it worked as desired.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JPA and mapping result sets to POJO:s