How to get lightweight objects from Hibernate without using proxy and/or lazy initialization?

I want to use some properties from a class in some situations and other properties in other situations, so my intetion was to instantiate the apropriate object in a query using "select new".

The following HQL statement works fine:


select new Store(store.id, store.description) from Store store

However I found that I could not do a nested instantiation like:

select new Store(store.id, store.description, new Section(store.section.id, store.section.name)) from Store store

I have the constructors to allow the instantiation, but the following Query Exception occurs:

net.sf.hibernate.QueryException: ( expected before ) in select [select new Store(store.id, store.description, new Section(store.section.id, store.section.name)) from Store store]


How can I solve this? It would be nice if we could have custom queries to fill the object according to our needs. In some cases I really do not want to get some properties and in other moments I need them. And we work disconnected from Hibernate session.

Thanks.

I don't think HQL supports nested new's.

We wanted to use nested new's feature, but as Hibernate didn't support it, we have done some custom changes in our Hibernate 2.1.6 source code in order to support it.

The changed classes were:
net.sf.hibernate.hql.QueryTranslator
net.sf.hibernate.hql.SelectParser
net.sf.hibernate.impl.IteratorImpl
net.sf.hibernate.impl.ScrollableResultsImpl

I would like to know if Hibernate Team has some interest to analyse this little contribution and maybe add this feature to future versions of Hibernate.
And if you want to see the code, how could we send it for your analysis?

Please post a JIRA issue and attach any files you might have. Thanks!