Retrieving result from a query with resultsetmapping using entity and columns

[David Acevedo]

Hello,
I am having some problems getting the information from a query that I did.
I specified a resultSetMapping like this:

@SqlResultSetMappings({
    @SqlResultSetMapping(
        name="ultimaEspecieByFecha",
        entities=@EntityResult(entityClass=Entities.Especie.class),columns=@ColumnResult(name="ultimaFechaDatos"))
})

In which I am putting the entity and an additional column that I bring in my sql query.

In my session bean I try to execute my query:

Query query = em.createNativeQuery(sqlQuery, "ultimaEspecieByFecha");
List listEspecies = query.getResultList();

I can ensure that the information is stored in the list, I even can check the size of the list and it is correct, but I do not know
how to access the data. To which type of date can I cast the result of the query?.

I am pretty new working with resultSetMapping when combining entities with columns ... please somebody can help me out with
this problem. I have been trying and looking for examples in the forums, but I have not get anything useful.

Thanks in advance for your help.

BR
David

[David Acevedo]

Solved!

        List<Object[]> listEspecies = query.getResultList();
        System.out.println("size: "+listEspecies.size());
        System.out.println("classname: "+listEspecies.getClass().getName());
        System.out.println("classname: "+listEspecies.get(0).getClass().getName());
        
        for(Object[] obj: listEspecies){
            System.out.println("obj0: "+obj[0]);
            System.out.println("obj1: "+obj[1]);
        }

In the position 0 of the obj array is the Entity and in the second is the scalar value generated by the column.

I hope this will be useful for somebody