retrive value not getting

[madhuchilipi reddy]

i write code like this .table is SUDHAN
Session session=Orasf.currentSession();
String vs="select max(sudhan.sno) from Sudhan sudhan";
Query qry=session.createQuery(vs);
List studList=qry.list();
Object o[]=studList.toArray();
for(int i=0;i<o.length;i++){
Sudhan s=(Sudhan)o[i];
System.out.println(s.getSno());



but i got exception like

Exception in thread "main" java.lang.ClassCastException: java.lang.Long
at org.student.Getting.main(Getting.java:17)
wt is the mistake in the code.

[David Madouros]

Madhuchilipi,

Anytime you use aggregation in HQL (max, min, count, sum, etc.), you do not get an instance of your object back. You only get a single column value (the max value of your 'sno' column as a Long in this case). To do what you are trying to do, you have to use a subselect. Your query should look like:

 
"from Sudhan s where s.sno = (select max(s2.sno) from Sudhan s2)"

Note: You would have to use a subselect with SQL also.