Hi,

The following hql throws an error of "could not resolve property: items of:"

string sql = "from Organization as o join fetch
o.Addresses a join fetch a.items x where x.Address1 like 'adr1'";
IQuery query = session.CreateQuery(sql);
return query.List<Organization>();

however if I construct the same query using ICreteria it works

ICriteria criteria = session.CreateCriteria(typeof
(Organization));
criteria.CreateAlias("Addresses", "alist");
criteria.CreateAlias("alist.items", "add");
criteria.Add(Expression.Like("add.State", "U%"));
return criteria.List<Organization>();

The mapping I am using is as follows

<class name="Organization" table="Organization" lazy="false">
<id name="OrganizationID" column="OrganizationID" type="int">
<generator class="native"/>
</id>
<property name="OrganizationName" column="OrganizationName"
type="String" not-null="true"></property>
<component name="Addresses">
<bag name="items" table="OrgAddressMap" lazy="false" cascade
="save-update" access="field">
<key column="OrganizationID"/>
<many-to-many class="Address" column="AddressID"/>
</bag>
</component>
</class>

What is wrong with the HQL statement?

Thanks

Anurag

Using "fetch" in HQL tells hibernate to load the collection items as a join. You should not mix that with restrictions on the collection. I suppose that the query works fine if you remove both or at least the second "fetch".


From the doc:



from http://www.nhforge.org/doc/nh/en/index.html#queryhql-joins

Hi,

I have tried removing the fetch as well but it still does not work. From the error message it seem that hql is unable to resolve the items alias, this rather surprising as ICreteria works perfectly.

Thanks

Anurag

Sorry, missed that on the first look: Addresses is a component, so you don't need a join ! CreateAlias probably ignores that. Try

from Organization as o join fetch
o.Addresses.items x where x.Address1 like 'adr1'

Hi,

"from Organization as o join fetch
o.Addresses.items x where x.Address1 like 'adr1'"

worked perfectly. Thanks for the same. I had another question, if I remove "fetch", I get an error. Can you tell me why?

Thanks

Anurag

What does the error/exception say ?

Hi,

Sorry for the late reply, the error message says "Could not execute query[SQL: SQL not available]", while the inner exception says

"The value "System.Object[]" is not of type "Organization" and cannot be used in this generic collection.
Parameter name: value"

Not sure what is going on. If I add the fetch everything works fine.

Thanks

Anurag

Without the fetch hibernate returns an array of organization + addres per resulting line instead of putting the addresses in the collection. "fetch" tells hibernate to fill the collection.

"select o from Organization o ..." would always return organizations, regardless if you specify fetch or not.

Hi,

Sorry for the late reply, the error message says "Could not execute query[SQL: SQL not available]", while the inner exception says

"The value "System.Object[]" is not of type and cannot be used in this generic collection.
Parameter name: value"

Not sure what is going on. If I add the fetch everything works fine.

Thanks

Anurag