Hi
I wounder if its possible in HQL to specify which propertys of an object i want to get. Lets say i have an objet with 3 many-to-one properties and 5 singel string properties. I just want to get the object with the string properties and 1 of the many-to-one properties. I also want it to get it as the type my object is. So an object[] is not the thing that i want.

Regards

If the many-one classes act as proxies (the default in NH 1.2), the many-one properties are lazy and are only filled with data when accessed.
And if you want the single many-one property to be loaded together with the string properties, use 'join fetch' in HQL.

Thanks but i think you miss understood my question.

I dont use lazy because of the way the application handles the session, we also use data transfer objects. I want to do the following in hql.

MyClass
Property, String:Name
Property, String:Id
Property, Bag: Logins
Property, Bag: Pictures

I want to get the the string properties and the Bag with logins in a hql-select.

Like
select p.Name, p.Id, elements(p.Logins) from Person p

Want it to NOT select the Pictures-bag, executing the query above, will not result in any hits. And if i leave elements out, it says it expect its.

Thanks