ClassCastException java.lang.Long in 4.0.4.GA

[dornus]

I had code that worked in previous releases of 4.0.4, but now gets ClassCastExceptions when run under 4.0.4.GA

It looks as though it is trying to interpret counts as a long instead of an integer. Is this a bug, or a change?

 private int getMyCount() {
 final Query q = em.createQuery(
 "select count(o) " +
 "from MyTable o "
 );
 return (Integer) q.getSingleResult();
 }

javax.ejb.EJBException: java.lang.ClassCastException: java.lang.Long

[dornus]

My Setup is:
-WinXP
-MySQL 5.0.21
-Connector/J 3.1.12

[sunfire]

COUNT was already supposed to return Long in the specs for a while now but there was a bug in the previous EJB3 release to return Integer. It got fixed in the last release so returning Long is the way it is supposed to be.

[dornus]

Thanks for the heads up!

How am I supposed to get the count then?

I cannot do something like

long myCount = (long)q.getSingleResult();

[dornus]

Nevermind I got it, just needed to capitalize it.

(Long)