ClassCastException when using HQL

Question

See the following mapping

public class SomeClass {

    private Integer someField;

}

When i call the following query

select someField, count(*) from SomeClass inner join OtherClass... group by ...

And i proccess the query as follows

Map<Integer, Integer> result = new HashMap<Integer, Integer>();

List<Object> objectList = query.list();
for(Object object: objectList) {
    Object [] objectArray = (Object []) object;

    result.put((Integer) objectArray[0], (Integer) objectArray[1]);
}

I get ClassCastException: can not convert Long to Integer

Question: what should i do to retrieve the values returned by the HQL as Integer instead of Long ????

Both answers are correct! (+1) Trank you!

Arthur Ronald
– Arthur Ronald

2010-02-23 15:40:50 +00:00
Commented Feb 23, 2010 at 15:40 — Arthur Ronald
– Arthur Ronald, Commented Feb 23, 2010 at 15:40

karoberts · Accepted Answer · 2010-02-23 15:01:10Z

3

If you don't know which it will be (Integer or Long), you can cast to Number and call intValue() or longValue(). This way an Integer or a Long will work.

result.put((Integer) objectArray[0], ((Number) objectArray[1]).intValue() );

The small downside with this is you end up unboxing the Number and reboxing it to put in the map.

answered Feb 23, 2010 at 15:01

karoberts

9,9484 gold badges43 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bozho · Accepted Answer · 2010-02-23 21:18:53Z

1

I guess the second column in the result - i.e. count(*) returns Long. You can get its int value by ((Long) objectArray[1]).intValue()

Or (as suggested), better change your map to Map<Integer, Long>, so that no information is eventually lost.

edited Feb 23, 2010 at 21:18

answered Feb 23, 2010 at 14:51

Bozho

599k147 gold badges1.1k silver badges1.2k bronze badges

1 Comment

BalusC Over a year ago

Note that you may lose information. Rather just use Long instead of Integer.

Collectives™ on Stack Overflow

ClassCastException when using HQL

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related