query results

spettlar · **Posted:** Sat Aug 21, 2004 1:02 pm

Hi,

Is it possible to get back the attribute names in a query result

<query name="Cat,name" >
select cat.name, cat.weight from Cat as cat
where cat.weight > :weight
</query>

Code:

Query query = getQuery(params);
Iterator results = query.iterate();
while (results.hasNext()) {
  Object[] object = (Object[])results.next();
  for (int i=0; i < object.length; i++) {

   ....
  }
}

In the body of the for loop i can get the value

Code:

object[i]

and its type

Code:

query.getReturnTypes()[i].getReturnedClass()

but can i get back which attribute or column each value comesfrom?

thanks
Simon

Hibernate version:2.1.4

Mapping documents:Cat

Code between sessionFactory.openSession() and session.close():as above

Full stack trace of any exception that occurs:na

Name and version of the database you are using:MySql 4.1.2 alpha

Debug level Hibernate log excerpt:na

mveitas · **Posted:** Sun Aug 22, 2004 1:11 pm

Take a look at Interceptor.onLoad().

Code:

/**
 * Called just before an object is initialized. The interceptor may change the <tt>state</tt>, which will
 * be propagated to the persistent object. Note that when this method is called, <tt>entity</tt> will be
 * an empty uninitialized instance of the class.
 *
 * @return <tt>true</tt> if the user modified the <tt>state</tt> in any way.
 */
public boolean onLoad(Object entity, Serializable id, Object[] state, String[] propertyNames, Type[] types) throws CallbackException;