Hi,

Lets say my db have the following tables:

TABLE-A TABLE-B
Col1(PK) ColB1
Col2 ColB2
Col3 ColB3
Col4
Col5

In TABLE-A, Col1 is mapped to Generator Class in hbm file.

In TABLE-B, my contents will be

ColB1 ColB2 ColB3
-----------------------------------
1 121 N
2 131 N
3 141 Y (Only one row will have 'Y')


I want to map the TABLE-A with this TABLE-B such that I get the SQL as follows:

SELECT <column-list of Table-A> FROM TABLE-A WHERE Col1=1 AND Col5=(SELECT ColB2 FROM TABLE-B WHERE ColB3='Y')

How do I change my hbm file for this?

Thanks.

Hi,
Use a class level filter for A.
<filter name="myFilter"
condition=" col5 = (SELECT ColB2 FROM TABLE-B WHERE ColB3='Y') "/>

If you are new to filters,
http://www.hibernate.org/hib_docs/v3/re ... lters.html
----------------------------------------
Rate the reply if you find it helpful

Thanks for the code.

Is it possible to have such a filter in UPDATE clause ?

something like

UPDATE TABLE-A SET Col2='blah-blah', Col3='bgg' WHERE Col1=1 AND Col5=(SELECT ColB2 FROM TABLE-B WHERE ColB3='Y')