HQL converting problem

[Samanthi perera]

this is my main class

import java.util.Iterator;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.classic.Session;

public class ViewQuery {

    public static void main(String[] args) {

        try {
            SessionFactory sessionfac = new Configuration().configure().buildSessionFactory();
            Session session = sessionfac.openSession();

            Person p1 = new Person();

            String hql = "select person.id from Person person";
            Query query = session.createQuery(hql);
            //int row = query.executeUpdate();

            for (Iterator itor = query.iterate(); itor.hasNext();) {

               Object[] row = (Object[]) itor.next();
                System.out.println("ID: " + row[0]);

            }

            session.close();

        } catch (Exception e) {
            e.printStackTrace();

        }

    }
}

this is Eror

INFO: Not binding factory to JNDI, no JNDI name configured
java.lang.ClassCastException: java.lang.Integer cannot be cast to [Ljava.lang.Object;
        at ViewQuery.main(ViewQuery.java:24)
BUILD SUCCESSFUL (total time: 1 second)

I tried changing 24 line by Integer[] row = (Integer[]) itor.next();
it also give Eooror

java.lang.ClassCastException: java.lang.Integer cannot be cast to [Ljava.lang.Integer;
        at ViewQuery.main(ViewQuery.java:24)
BUILD SUCCESSFUL (total time: 1 second)

[Victor Dolirio]

Hello Samanthi,

In your hql, you're projecting the ID of the person. This ID is a value of type Integer, just how you mapped that. So you MUST to get it with a variable of Integer type and not an array. Try this on line 23:

Integer row = (Integer) itor.next();  

[Charan kumar sarvepalli]

Hi,

In your HQL in select clause you have only one column defined to return, so the hibernate returns object only.
if you have defined multiple columns in the select clause then definitely it returns object[].