Hibernate retrieve multiple rows and store in an object array

Question

I am trying to retrieve multiple rows of students from the database and then store them in a list of Student Objects. My Code is as follows

Session session = this.sessionFactory.getCurrentSession();
String sql = "SELECT * FROM STUDENTS WHERE class=:clsid";
SQLQuery query= session.createSQLQuery(sql);
query.setParameter("clsid", clsid);
List<Students> stdnts= new ArrayList<Students>();
stdnts = query.list();
System.out.println("First name "+stdnts.get(0).getName());

This throws an error and did not print the value of the name variable.

java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to com.test.stuff.model.Students

from the line

System.out.println("First name "+stdnts.get(0).getName());

How do I fix this?

Does this answer your question? java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to — sovannarith cheav
– sovannarith cheav, Commented Nov 6, 2019 at 6:47

Ganesh Kumar · Accepted Answer · 2019-11-06 07:13:19Z

1

Hi Monty put addEntity method before list method like stdnts = query.addEntity(Students.class).list(); then it dont throw classCast exception.

answered Nov 6, 2019 at 7:13

Ganesh Kumar

768 bronze badges

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

1 Comment

Monty Swanson Over a year ago

Solved my problem. Thanks

Collectives™ on Stack Overflow

Hibernate retrieve multiple rows and store in an object array

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related