Ljava lang Object cannot be cast to

Question

I want to get value from the database  in my case I use List to get the value from the database but I got this error   Exception in thread  main  java lang ClassCastException   Ljava lang Object  cannot be cast to id co bni switcherservice model SwitcherServiceSource at id co bni switcherservice controller SwitcherServiceController LoadData SwitcherServiceController java 48  at id co bni switcherservice controller SwitcherServiceController main SwitcherServiceController java 62    this is my code       Query LoadSource   session source createQuery  select CLIENT SERVICE SERVICE TYPE PROVIDER CODE COUNT    FROM SwitcherServiceSource                  where TIMESTAMP between  awal and  akhir                  and PROVIDER CODE is not null group by CLIENT SERVICE SERVICE TYPE PROVIDER CODE order by CLIENT SERVICE SERVICE TYPE PROVIDER CODE        LoadSource setParameter  awal   fromDate       LoadSource setParameter  akhir   toDate        List lt SwitcherServiceSource gt  result source    List lt SwitcherServiceSource gt   LoadSource list        for SwitcherServiceSource tes   result source           System out println tes getSERVICE             any help will be pleasure      raffian  did you mean like this    List lt Switcher gt  result    List lt Switcher gt   LoadSource list    for Switcher tes   result       System out println tes getSERVICE

User · Accepted Answer

java lang ClassCastException   Ljava lang Object  cannot be cast to id co bni switcherservice model SwitcherServiceSource   Problem is    List lt SwitcherServiceSource gt   LoadSource list      This will return a List of Object arrays  Object    with scalar values for each column in the SwitcherServiceSource table  Hibernate will use ResultSetMetadata to deduce the actual order and types of the returned scalar values   Solution  List lt Object gt  result    List lt Object gt   LoadSource list     Iterator itr   result iterator    while itr hasNext        Object   obj    Object    itr next         now you have one array of Object for each row    String client   String valueOf obj 0       don t know the type of column CLIENT assuming String     Integer service   Integer parseInt String valueOf obj 1       SERVICE assumed as int      same way for all obj 2   obj 3   obj 4      Related link   Using iterator

User · Answer

Your query execution will return list of Object     List result source   LoadSource list    for Object   objA   result source           read it all

User · Answer

In case entire entity is being return  better solution in spring JPA is use  Query value    quot from entity where Id in  ids quot   This return entity type rather than object type

User · Answer

You need to add query addEntity SwitcherServiceSource class  before calling the  list   on query

User · Answer

I ve faced such an issue and dig tones of material  So  to avoid ugly iteration you can simply tune your hql   You need to frame your query like this   select entity from Entity as entity where      Also check such case  it perfectly works for me   public List lt User gt  findByRole String role         Query query   sessionFactory getCurrentSession   createQuery  select user from User user join user userRoles where role name  role name        query setString  role name   role        SuppressWarnings  unchecked       List lt User gt  users    List lt User gt   query list        return users      So here we are extracting object from query  not a bunch of fields  Also it s looks much more pretty

[java] [Ljava.lang.Object; cannot be cast to

Solution

Related link

Examples related to java

Examples related to hibernate

Examples related to hql