How to resolve java.lang.ClassCastException: for query.list() in hibernate

Question

I am performing select option using Hibernate, Query is executing but getting exception at query.list() method,

Here is my code,

String hql="select a.vehicleno, a.lat, a.lng, a.status, a.rdate, a.rtime from LatitudeBean a, VehicleRegisterBean b where a.vehicleno=b.vehicleno and b.clientid= :clientId and b.groupid in(select groupid from GroupDetails where groupname= :groupname and clientid= :gdclientId)"; // valid query
Query query =sessio.createQuery(hql);
List<LatitudeBean> groupList = (List<LatitudeBean>)query.list(); //Here I am getting exception
for(LatitudeBean arr : groupList){
        System.out.println(arr.getVehicleno());
    }

Exception is,

java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to com.aurodisplay.its.beans.LatitudeBean
at com.abc.its.controller.LoginController.doPost(LoginController.java:83)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)

How to cast list returning from list() method . Anyone help me in this please.

Post your exception stacktrace as well.

Buhake Sindi
– Buhake Sindi

2014-08-27 10:38:59 +00:00
Commented Aug 27, 2014 at 10:38 — Buhake Sindi
– Buhake Sindi, Commented Aug 27, 2014 at 10:38

icza · Accepted Answer · 2014-08-27 10:49:01Z

8

The problem is that your query does not select entities, but just properties of entities.

Therefore the result will not be a list of entities, but a list of object arrays (which arrays will hold the selected properties).

Try this:

List<Object[]> groupList = (List<Object[]>) query.list();
for(Object[] arr : groupList) {
    System.out.println("vehicleno: " + arr[0]);
}

Or if you want to select entire entities, modify your query like this:

String hql = "select a from LatitudeBean a, VehicleRegisterBean b where ...";

And that way your original code will work.

edited Aug 27, 2014 at 10:49

answered Aug 27, 2014 at 10:43

icza

423k78 gold badges1k silver badges905 bronze badges

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

5 Comments

Raghu Over a year ago

oh k . . then how can I change it.

Raghu Over a year ago

Here all selected properties are from LatitudeBean. So do I need to change in query or in logic.?

icza Over a year ago

Added how you can process the result.

Raghu Over a year ago

cant we change for LatitudeBean because what I am selecting are all the only fields in LatitudeBean.

icza Over a year ago

Yes, you can. Modify your query to return the "whole" entities. Added to the answer.

Collectives™ on Stack Overflow

How to resolve java.lang.ClassCastException: for query.list() in hibernate

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related