Hi,

I'm using Hibernate EntityManager API (v3.3.1) for executing a native query that returns a set of integer values, one integer per row.
Hibernate automatically maps the values to BigDecimal type, but I'd like to use Long.
Can I explicitly specify the result type here somehow?

Yes, you should be able to because this functionality is supported in core Hibernate. I was able to designate a type:

<sql-query name="BssDailyStat.findByTotalTxMegabytesTopN" >
<return-scalar column="sectorName" type="java.lang.String"/>
<return-scalar column="sectorNbr" type="java.lang.Integer"/>
select statement .....
</sql-query>

The query is being generated dynamically by the application and I'm using the JPA API.
Any ideas on how I could specify the result type in this case?

Hi,
This thread was in a different forum, but may help.

http://forums.java.net/jive/message.jsp ... eID=250807

Regards,
Lynette


@Stateless(name="ImagesServiceImpl")
public class ImagesServiceImpl implements ImagesService {

@PersistenceContext
EntityManager em;

public Long getNewImageId() {
Query q = em.createNativeQuery(
"SELECT nextval('global_next_image_id_seq') AS ID");
try {
return (Long)((List) q.getSingleResult()).get(0);
}
catch(Exception ex) {
throw new RuntimeException(ex.getMessage(), ex);
}
}

}