ClassCastException with java List Iterator with Generics

Question

I'm trying to display the names of the hotels using Hibernate. But when I'm iterating the list of hotels which I have got from the database, iter.next() gives a ClassCastException saying Object cannot be cast to Hotel class. This is my method.

public List<Hotel> getAllHotels()
{
    List<Hotel> contracts = new ArrayList<Hotel>(  );
    Transaction tx = null;
    Session session = SessionFactoryUtil.getCurrentSession();
    try
    {
        tx = session.beginTransaction();
        contracts = session.createSQLQuery("select * from HOTEL").list();
        System.out.println("*** Content of the Hotel Table ***");
        System.out.println("*** Start ***");
        for ( Iterator<Hotel> iter = contracts.iterator(); iter.hasNext();) {
            Hotel h =  iter.next();
            System.out.println(h.getHotelName());
        }
        System.out.println("*** End ***");
        tx.commit();
    }
    catch( RuntimeException e )
    {
        if( tx != null && tx.isActive() )
        {
            try
            {// Second try catch as the rollback could fail as well
                tx.rollback();
            }
            catch( HibernateException e1 )
            {
                System.out.println( "Error rolling back transaction" );
            }
            // throw again the first exception
            throw e;
        }
    }
    return contracts;
}

I have used Generics for the List and Iterator but cannot figure out the error. Any help is appreciated.

Looks like the objects have a different class? And you probably want to add your exception stack trace — GhostCat
– GhostCat, Commented Apr 20, 2017 at 3:54

Sripriya V · Accepted Answer · 2017-04-20 04:14:47Z

2

Looks like you may need to add the entity when creating the SQLQuery.

Refer https://www.mkyong.com/hibernate/hibernate-native-sql-queries-examples/

session.createSQLQuery("select * from HOTEL").addEntity(Hotel.class).list();

Or if using your current code, iterate through the object array

List result = query.list();
for(Object object : data)
         {
             //Logic 
         }

answered Apr 20, 2017 at 4:14

Sripriya V

2953 silver badges8 bronze badges

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

2 Comments

Lak Over a year ago

Calling addEntity() solved the problem. Thank you very much :)

Sripriya V Over a year ago

Glad that helped!

Collectives™ on Stack Overflow

ClassCastException with java List Iterator with Generics

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related