A Tour is driven by one or more vehicles (e.g. truck and trailer)
A Vehicle drives more than one Tour.
The query should give all Tours, that are driven by the Vehicle upon others.
That's why I don't see any alternative to the in operator except something like
retrieve all Tours (OQL)
walk through that list and collect all Tours that contain the Vehicle in the list returned by their getVehicles() method.
BTW That's why I guessed it might possible to use contain in the OQL directly.
Regards, michael
At 16:27 02.07.2003 +0400, you wrote:
Ok, in your case you not need to use LIST IN operator, I guess: SELECT o FROM TOUR o WHERE o.vehicle = $1
Somethink like that
Thanks
-----Original Message----- From: michael simons [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 4:24 PM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] in- or contains-operator
Hello Alexey,
A list like the ones you showed would get rather large. I must assume about 100 000 Tour instances that might be driven by the given vehicle, but I think I have to give it a try.
The contains operator was just a shot in the dark by me.
thanks, michael
At 16:07 02.07.2003 +0400, you wrote: >Hi, > >1. IN LIST operator support syntax like: > >select o from Object o where id in list(1, 2, 3, 4), if values is >numeric and select o from Object o where id in list("1", "2", "3", >"4"), if values is stringable >To perform automatical list OQL generation I use my framework >(http://sourceforge.net/projects/phantom-castor/) it have OQLPreparator >for it. For example: > >List idList = new ArrayList(); >idList.add("1"); >idList.add("2"); >idList.add("3"); >String oql = OQLPreparator.prepareOQL( > new Select(A.class), > new WhereInList("id", idList) >); > >The result will be: >SELECT o FROM package.to.class.A o WHERE id IN LIST("1", "2", "3") > >2. What is "contains" operator? I don't know it... Are you sure that it
>is avable now? http://www.castor.org/oql.html#Syntax > >Thanks! > > >-----Original Message----- >From: michael simons [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 02, 2003 3:53 PM >To: [EMAIL PROTECTED] >Subject: [castor-dev] in- or contains-operator > > >Hi all, > >I want to do a query like the following > >query = db.getOQLQuery("select t from Tour where $1 in >LIST(t.vehicles)"); query.bind(aVehicle); > >or > >query = db.getOQLQuery("select t from Tour where t.vehicles >contains($1)"); query.bind(aVehicle); > >Does anybody know how to do this (both my attempts lead to exceptions)? > >Regards, >michael > >----------------------------------------------------------- >If you wish to unsubscribe from this mailing, send mail to >[EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > >----------------------------------------------------------- >If you wish to unsubscribe from this mailing, send mail to >[EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
