Hibernate: Problem getting a simple list

[Gregg Bolinger]

I am trying to get a simple list of departments from an employee table in my database using Hibernate. Appearntly this simple task is fairly difficult since Hibernate is all about populating objects with data. Anyway, here is the query I am using:

Query query = session.createSQLQuery("select a.department as {employeez.department} from employee_table a", "employeez", Employee.class);
List results = query.list();

the createSQLQuery uses the Employee.class to determine the column, I think, so here is my Employee.hbm.xml

<hibernate-mapping>
 
    <class name="com.intrustbank.anykey.beans.dao.Employee" table="employee_table">
 
        <id name="id" column="ID" type="int" >
            <generator class="identity"/>
        </id>
        <property name="empid" column="empid" type="java.lang.Integer"/>
        <property name="firstName" column="firstname" type="java.lang.String"/>
        <property name="lastName" column="lastname" type="java.lang.String"/>
        <property name="department" column="department" type="java.lang.String"/>
        <property name="phone" column="phone" type="java.lang.String"/>
        <property name="mailStop" column="mailstop" type="java.lang.String"/>
        <property name="email" column="email" type="java.lang.String"/>
        
    </class>
 
 </hibernate-mapping>

I am getting the following exception:

SEVERE: SQLException occurred
java.sql.SQLException: Column 'ID0_' not found.
at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:2320)
at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:1294)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:220)
at net.sf.hibernate.type.IntegerType.get(IntegerType.java:18)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:62)
at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:53)
at net.sf.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:352)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:203)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)
at net.sf.hibernate.loader.Loader.doList(Loader.java:955)
at net.sf.hibernate.loader.Loader.list(Loader.java:946)
.....

Any ideas?

[Paul Sturrock]

Hibernate is claiming your ID column doesn't exist in the DB. Is it there?

[pascal betz]

hi Gregg

why do you use SQL ?

if i got it right, then you can use

List list = sess.find("select emp.department from com.intrustbank.anykey.beans.dao.Employee as emp")

the hibernate reference has a chapter on
HQL
in section 11.4 you can find some examples for the thing (i think) you want to do.