can use expression: select new classname with createSQLQuery

worldcreatxr · **Joined:** Sat Apr 10, 2004 8:39 pm **Posts:** 84

we can use expression: select new classname(table1.field...) from Table1 table1 where .............

with Query query = session.createQuery(...........

can use expression: select new classname (........)

with createSQLQuery

wsoumer · **Posted:** Wed Mar 23, 2005 5:36 am

Hi worldcreatxr!!
I think you can't pass HSQL queries to the createSQLQuery method.
Regards.
Walid.

max · **Posted:** Wed Mar 23, 2005 6:03 am

select new is not SQL syntax ,)

(but you could put entry in the jira for a wish to be able to set the returnclass of a query to be your own class and we would construct it and call setters on it ....)

/max