Hibernate version:3

Mapping documents:see below

Name and version of the database you are using:MySQL(latest)


I have an object mapping that contains two sets as follows:

....<class....(owningClass)>....

<set name="b"
lazy="false"
table="b"
sort="unsorted"
inverse="false"
optimistic-lock="true">
<key column="a_ID" on-delete="noaction" />
<element type="string" column="bName"
not-null="false" unique="false" />
</set>

<set name="c"
lazy="false"
table="c"
sort="unsorted"
inverse="false"
optimistic-lock="true">
<key column="a_ID" on-delete="noaction" />
<element type="string" column="cName"
not-null="false" unique="false" />
</set>


....</class>


I am trying to write a query to return the objects of the owning class such that:

((owningClass.id = a.a_ID and a.aName=?) OR
(owningClass.id = b.a_ID and b.bName=?))


I have something like...
<query name="a.getAsForbNameOrcName"><![CDATA[
select a
from A a inner join a.b ar inner join a.c au
where ((a.id = ar.a_ID) and (ar.bName = ?)) or
((a.id = au.a_ID) and (au.cName = ?))
]]></query>

I have also tried....

<query name="a.getAsForbNameOrcName"><![CDATA[
select a
from A a
where ((a.id = a.b.a_ID) and (a.b.bName = ?)) or
((a.id = a.c.a_ID) and (a.c.cName = ?))
]]></query>


I always get....

"org.hibernate.QueryException: cannot dereference scalar collection element: a_ID ....."


Any help would be appreciated.


Seamus