Dyanmic Instantiation w/ SQL queries

clajoie · **Posted:** Tue Dec 14, 2004 3:30 pm

I was wondering if it was possible to use dynamic instantiantion in regular SQL queries with Hibernate. In other words could I do this

select new FooObject(col1, col2, col3) from tableFoo where col1='someText'

I know the above query actually ends up being an SQL/HQL hybrid, but I wasn't sure if it was possible or not.

Hibernate version:
2.1.6

michael · **Posted:** Tue Dec 14, 2004 11:22 pm

No, select new is only possible in pure HQL.