FW: [Hibernate] where clause for collections.

2004-10-28 Thread Caldas, Marcelo
ganization. That's the query you see below. Thanks again, Marcelo. -Original Message- From: Gavin King [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 11:37 AM To: Caldas, Marcelo Cc: [EMAIL PROTECTED] Subject: Re: [Hibernate] where clause for collections. And this is wha

Re: [Hibernate] where clause for collections.

2004-10-28 Thread Gavin King
in King Sent: Wednesday, October 27, 2004 9:49 AM To: Caldas, Marcelo Cc: [EMAIL PROTECTED] Subject: Re: [Hibernate] where clause for collections. Caldas, Marcelo wrote: And then I use the where="active_ind=1" to retrieve only active children. First problem is I'm getti

RE: [Hibernate] where clause for collections.

2004-10-27 Thread Caldas, Marcelo
_" And last line where "_active_ind-1", but I have an _active_ind on every single table part of that from clause. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gavin King Sent: Wednesday, October 27, 2004 9:49 AM To: Caldas, Marcelo Cc:

Re: [Hibernate] where clause for collections.

2004-10-27 Thread Gavin King
Caldas, Marcelo wrote: 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. Hibernate should automatically prefix the column name. What does the

FW: [Hibernate] where clause for collections.

2004-10-27 Thread 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

Re: [Hibernate] where clause for collections.

2004-10-27 Thread Emmanuel Bernard
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.

[Hibernate] where clause for collections.

2004-10-27 Thread Caldas, Marcelo
I’ve been trying to use the where clause for 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.