FW: [Hibernate] where clause for collections.

[Caldas, Marcelo]

How can I solve my problem then?   From: Emmanuel Bernard [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 8:40 AM To: Caldas, Marcelo Cc: [EMAIL PROTECTED] Subject: Re: [Hibernate] where clause for collections.   Caldas, Marcelo wrote:   Shouldn’t it be better if I could specify a HQL for the where clause and Hibernate put the sql together for me?   No, usually where clause apply to non mapped columns.   Original message: FROM: Caldas, Marcelo.     I’ve been trying to use the where clause for <set> on hibernate for quite a long time.   The main reason I’m using it is because we’re implementing a soft-delete (setting a flag to 0, instead of a SQL DELETE statement). And then I use the where=”active_ind=1” to retrieve only active children.   First problem is I’m getting “ambiguous column name ‘active_ind’” because most of the tables have an active_ind column – same name.   I tried solving this problem by adding the set name for the where clause:  <set … where=”orgTypes.active_ind=1”>   It didn’t work, because the real name for the orgTypes is “orgTypes0_”. Therefore orgTypes is not valid.   Shouldn’t it be better if I could specify a HQL for the where clause and Hibernate put the sql together for me?   How can I solve this problem?   Thanks, Marcelo.