Failed to count the number of records in Hibernate:java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.lang.Integer

Question

I encountered a very urgly problem when I's trying to count the number of records using Hibernate. By debuging I get the HQL and related error:

HQL:

SELECT COUNT(id) AS totalSize FROM UserAccount WHERE 1 = 1 AND role IN (:role_list) AND agent.id = :agentId

Set Parameter:

query.setParameter("role_list", parameter.getRoles());
query.setParameter("agentId", parameter.getAgentId());

Error:

java.lang.ClassCastException: java.util.ArrayList cannot be cast to java.lang.Integer

I'm confused with that since It worked fine previously when I set its parameter with sequence instead of name. Can anybody give me ideas for that.

Thanks in advance.

Brady Zhu · Accepted Answer · 2013-10-31 03:30:34Z

2

Stupid question, I should set collection parameter with the method of 'setParameterList'.

answered Oct 31, 2013 at 3:30

Brady Zhu

1,4155 gold badges23 silver badges45 bronze badges

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

1 Comment

I guess you could simply remove your question! ;)