HQL (Searching) for "Any" type mappings

jellyfish8899 · **Joined:** Tue Mar 23, 2004 8:40 pm **Posts:** 22

Folks,

I would like to search "Requisition" via Client's attribute (e.g. code). This should be a simple one, however, I haven't been able to find any information about this, anyone can help?


<class name="Requisition"
table="requisition"
optimistic-lock="version"
>
...
<any name="Client" id-type="string" meta-type="string">
<meta-value value="1" class="InternalClient"/>
<meta-value value="2" class="ExternalClient"/>
<column name="client_type"/>
<column name="client_id"/>
</any>
...
</class>

Thanks in advance,

Martin

gavin · **Posted:** Tue Jul 20, 2004 11:10 am

You need to do a where-clause (theta-style) join.

Code:

from Requisition r, Client c 
where r.Client.id = c.id and ....

jellyfish8899 · **Joined:** Tue Mar 23, 2004 8:40 pm **Posts:** 22

select count(*) from Requisition as r, client as c where r.client.id = c.id

-> net.sf.hibernate.QueryException: unexpected token

select count(*) from Requisition as r, r.client as c where r.client.id = c.id

-> Hibernate: select count(*) as x0_0_ from requisition requisitionv0_ where (requisitionv0_.client_id=requisitionv0_.objId )
(it does not join to the table of "InternalClient" or "ExternalClient")

P.S.
Typo for my previous posting:
<any name="Client"
<any name="client"

Any thoughts?

anthony · **Posted:** Wed Jul 21, 2004 2:54 am

r.client.id = c.id

i think id is a protected keyword

jellyfish8899 · **Joined:** Tue Mar 23, 2004 8:40 pm **Posts:** 22

Anthony, do you mind to explore a bit ...