Thanks. Since I'm on Jackrabbit 1.6 SQL2 is not an option. I guess I'll have to do it programmatically although this is far less efficient. But thanks for the confirmation that it's not possible. At least I know now that I'm not doing anything wrong...
-will On 19.08.2010, at 15:09, Alexander Klimetschek wrote: >> but afaik >> - the count() function is not implemented by Jackrabbit >> - XPaht does not allow "subqueries" like this > > Yes, I think you won't be able to do such a query with JCR Xpath. It > might be possible with JCR 2.0 SQL2's join feature. Otherwise you have > to do that join yourself by doing multiple queries, ie. find all rooms > first and take out all that have a reservation for the given time > span. > > Regards, > Alex > > -- > Alexander Klimetschek > [email protected]
