Using Java 1.5 and Hibernate versions referred in subject,
just a simple line like

int count = (Integer) session.createQuery("select count(*) from mytable").uniqueResult()


causes a ClassCastException in Hib3.2.6GA BUT IT DOES NOT in Hib3.2.5GA

¿!?¿!?¿!?¿! A BUG ???

Here's an idea.

Just cast it into an object, and then do a getClass() call on the object that is returned. Then post back and tell us what the object type is! That should answer pretty much all the questions, and help out everyone else that runs into a similar problem.

Relatively interesting your proposal, and very interesting results :::

----------
final Object count = session
.createQuery("select count(*) from ModuleJar").uniqueResult();
System.err.println("result:::" + count.getClass());
-----------

and guess what? Integer results ......reaaaaaally funny.

Any way it's obviously something i've worked around with some code like this:::

final Object count = session
.createQuery("select count(*) from ModuleJar").uniqueResult();
int num = Integer.parseInt(""+count)

Not elegant, rather stupid, but that's it. In former version it worked as expected and as I upgraded this silly matter arose.

I think 'select count(*) ..' returns a long

The above is correct - there was a change in the return type for a Count.

I love it when a plan comes together. :)

Troubleshooting can be fun.