java class cast Exception Error

Question

I'm developing my website in struts, hibernate and jsp. I had called a function which is in my DAO page from my action page like this:

private List<Order> salesDetails = new ArrayList();
salesDetails = doctorDao.getInstance().getDoctorSalesDetails(SessionObj.getId(),activityGraph);

and in my dao function I write the code like this

public List getDoctorSalesDetails(int id,int activityGraph){
    List<Order> doctorSalesDetails=new ArrayList();        
    try{
       SessionFactory sessionFactory =
                (SessionFactory) ServletActionContext.getServletContext().getAttribute(HibernateListener.KEY_NAME);
        Session Hibernatesession = sessionFactory.openSession();
        Hibernatesession.beginTransaction();
        doctorSalesDetails =    Hibernatesession.createSQLQuery("SELECT total_amount,created_at FROM `order` WHERE created_at > DATE_SUB(curdate(),INTERVAL "+activityGraph+" DAY) AND doctor_id = "+id+" GROUP BY created_at").list();
        Hibernatesession.getTransaction().commit();
    }catch(Exception e){
        e.printStackTrace();
    }
    return doctorSalesDetails;
}

The query result is successfully working here. The problem is when I access the the return variable from my action page like this:

    try{
       for( Order o:  salesDetails) {
           System.out.println("Total amount="+o.getCreatedAt());
       }
    }catch(Exception e){
        e.printStackTrace();
    }

it causes following error :

java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to com.myDrDirect.hbmobj.Order
    at com.myDrDirect.doctor.action.DoctorDashBoardActivity.getDashBoardActivityDetails(DoctorDashBoardActivity.java:36)

What might be the issue?

Sabya · Accepted Answer · 2011-12-26 13:10:53Z

2

private List<Order> salesDetails = new ArrayList();

salesDetails = doctorDao.getInstance().getDoctorSalesDetails(SessionObj.getId(),activityGraph);

In the above statement salesDetails must accept elements which is of type "Order" .

doctorSalesDetails =    Hibernatesession.createSQLQuery("SELECT total_amount,created_at FROM `order` WHERE created_at > DATE_SUB(curdate(),INTERVAL "+activityGraph+" DAY) AND doctor_id = "+id+" GROUP BY created_at").list();

In the above line doctorSalesDetails is of type "Object" and the same thing you are returning to salesDetails.

So as per your statement

salesDetails which is expected to hold a Order is holding an Object.

As a result , its throwing ClassCastException .

answered Dec 26, 2011 at 13:10

Sabya

1,4371 gold badge10 silver badges14 bronze badges

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

1 Comment

anoop Over a year ago

You are correct Hibernate SQLQUery function returns the data in different format even if i am retrieve the data from order table. I think i need to change the query. Any way thanks.

Kylar · Accepted Answer · 2011-12-26 13:09:38Z

1

The fact that you're declaring the List to hold Order is only a compile time issue. If the list that's passed in doesn't contain Order objects (or Hibernate doesn't return them properly), you can run into this problem. You're probably going to have to do something like this:

for( Object obj:  salesDetails) {
         if(obj instanceof Order){
            Order o = (Order)obj;
           System.out.println("Total amount="+o.getCreatedAt());
         }
}

answered Dec 26, 2011 at 13:09

Kylar

9,37410 gold badges46 silver badges76 bronze badges

Comments

Ophir Radnitz · Accepted Answer · 2011-12-26 13:10:23Z

1

You're using Hibernate's native SQL scalar queries by invoking list() which returns a list of Object arrays, its values you can then map into your own types.

If you want Hiberate to automatically map the entities for you, try entity SQL queries like so (assuming your entities map nicely from the fetched columns):

doctorSalesDetails = Hibernatesession.createSQLQuery("SELECT total_amount,created_at FROM `order` WHERE created_at > DATE_SUB(curdate(),INTERVAL "+activityGraph+" DAY) AND doctor_id = "+id+" GROUP BY created_at").addEntity(Order.class);

answered Dec 26, 2011 at 13:10

Ophir Radnitz

1,8332 gold badges21 silver badges18 bronze badges

Comments

bmargulies · Accepted Answer · 2011-12-26 13:08:39Z

0

You are using a combustible mixture of generics and non-generics, which is prone to all sorts of errors.

private List<Order> salesDetails = new ArrayList();

should be ArrayList<Order>.

You seem to think that the hibernate call will return a list of Order objects, but it has apparently returned something more like List<Object[]>. Read the documentation for the Hibernate API and learn what it is returning.

answered Dec 26, 2011 at 13:08

bmargulies

101k40 gold badges196 silver badges327 bronze badges

Collectives™ on Stack Overflow

java class cast Exception Error

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related