Hi friends,

I need to do any thing like this:

String sql = "select cat.originalId as {cat.id}, cat.mateid as {cat.mate}, cat.sex as {cat.sex}, cat.weight*+ " from cat_log cat where {cat.mate} = :catId"

List loggedCats = sess.createSQLQuery(sql, "cat", Cat.class)
.setLong("catId", catId)
.list();

This examples able me to select attributes from many places to a unique class.

But... this example is a SQL query. I need to do it using HQL queries.

Any way or no way?


tks for any help,

Paulo Marcio