Thanks for your suggestion, it would be nice and clean too. Unfortunately, I'm pretty sure the target DB is mysql, which AFAIK doesn't support views.
Colin
McKinstry, Pete (HQP) wrote:
Colin-
I'm new to OJB, so i don't know of a way to do what you're attempting w/in
OJB. (others may chime in here) But you could use a view (assuming your DB
supports them) & have the mapping point to the view table which only shows
the valid/active rows.
just a possible work-around...
-pgm
-----Original Message-----
From: Colin Kilburn [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 19, 2003 11:48 AM
To: [EMAIL PROTECTED]
Subject: where-clause criteria for collection-descriptor?
Hi All,
I'm sorry if this question has been asked before, the archive search capability seems to be broken.
This is my first project using OJB, and I enjoy the convenience of the collection-descriptor/inverse-foreignkey mapping. What I'd like to do however is specify additional criteria as to what records are populated in the collection. For example, I would like to have only records whose "active" attribute is set to "true" to appear in the collection. Looking in the repository.dtd it doesn't look like I can do this declaratively.
Can anyone give me a hint as to how I would go about this?
I will gladly provide more detail if it's not clear what I'm trying to do. Please let me know.
Thanks in advance,
Colin
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
