JPA and mapping result sets to POJO:s

[E Erik Svensson]

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:

    
@NamedNativeQueries ({
        @NamedNativeQuery (
                name = "SequenceId.getFreeIds",
                query = "{call getFreeLeasesForSequenceName(?,?)};",
                resultClass = SequenceIdRaw.class

        ),
        @NamedNativeQuery (
                name = "SequenceId.insertLeases",
                query = "{call insertLeases(?)};",
                resultClass = InsertLeaseError.class
        ),
        @NamedNativeQuery (
                name = "SequenceId.updateLeases",
                query = "{call updateExpiryDateForLeases(?)};",
                resultClass = UpdateLeaseError.class
        )
})

The InserLeaseError class:

    
public class InsertLeaseError implements Serializable {

    private int sequenceId;
    private int sequenceRangeFK;
    private String  reference;
    private String ERROR_MESSAGE;

    // getters and setters removed for brevity

And the code that ties it all together:

   

    public void release(final String pIds) {
        final EntityManager em =  getEntityManager();

        try {
            new TransactionBlock(persistenceUnit, context) {
                protected void doInTransaction() {
                    TypedQuery<InsertLeaseError> q = em.createNamedQuery("SequenceId.insertLeases", InsertLeaseError.class);

                    q.setParameter(1,pIds);
                    List<InsertLeaseError> l = q.getResultList();

                    if (l.size() > 0) {
                        System.out.println("Error in insert");
                        for (InsertLeaseError ile : l) {
                            System.out.println("Error : "+ile);
                        }
                    }

                }
            }.execute();
        } finally {
            if (em != null) {
                em.close();
            }
        }
    }

 

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

    
Caused by: org.hibernate.HibernateException: Errors in named queries: SequenceId.insertLeases, SequenceId.updateLeases
	at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:437)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1385)
	at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:954)
	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:891)
	... 11 more

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]

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.