File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 Android Security Essentials Live Lessons this week in the Android 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.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: JPA and mapping result sets to POJO:s
 
Similar Threads
Stored Procedures + Hibernate + Xml mapping
Mapping to an xml typed column (PostgreSQL) on an EJB3 entity in JBoss 5.1
TypedQuery in JPA?
Stored procedures JPA and mappings
@NamedNativeQuery and choosing the correct resultClass