Help casting query object HQL

user_hibernate · **Joined:** Thu Jun 15, 2006 5:58 pm **Posts:** 18

I have a HQL query where i select the column from different tables. I have a problem casting the query object. Can some one tell
how to iterate over this query object and get the individual columns.

sql.append(" select contract.organization.name, contract.organization.orgLevel, contractseason.season.name,")
.append(" contractseason.contractStatus, contractproduct.products.name ")
.append(" from ContractSeason contractseason join contractseason.organizationContracts contract " )
.append(" join contractseason.contractprod contractproduct ");
Query q = sess.createQuery(sql.toString());

Can somebody help me on this.

CWitherow · **Posted:** Thu Sep 07, 2006 10:30 am

As you have the query, you will get an Object[] for each row returned.

If you want to be more specific in accessing the returned data, take a look at dynamic instanciation -- i.e.

Code:

SELECT new CustomBean(obj1.prop1, obj2.prop1, ...) FROM Object1 obj1 JOIN obj1.object2 obj2

Curtis