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
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
_"
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:
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
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
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.
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.