jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcel Reutegger <marcel.reuteg...@gmx.net>
Subject Re: writing a join query in jackrabbit 1.x and jsr 170
Date Fri, 09 Oct 2009 08:09:40 GMT
Hi,

JCR 1.0 does not specify joins, hence jackrabbit 1.x does not support
them. you have to do the join manually in your code.

JCR 2.0 specifies joins [0] and jackrabbit 2.0 will support them.
please note that aggregate functions (such as count()) are not
specified.

regards
 marcel

[0] http://www.day.com/specs/jcr/2.0/6_Query.html#6.2.2 Joins

On Thu, Oct 1, 2009 at 17:08, sidhama <sidhartha.mallik@wipro.com> wrote:
>
> Guys,
> I want to convert the following sql query  to jackrabbit query either in
> xpath or sql.
> -----
> select count(requestparammediasrcpath) from <release>, <server> where
> release.reqparamreleaseserverID = server.serverID and server.ftpaddress =
> '<release server ftp address>' and server.userName = '<release server user
> name> and server.password ='<release server password>'  and
> server.rootpath='<release server rootpath>'
> -----
>
> Is it possible, as i did not get any resolution in specs i need your
> suggestions.
> --
> View this message in context: http://www.nabble.com/writing-a-join-query-in-jackrabbit-1.x-and-jsr-170-tp25696923p25696923.html
> Sent from the Jackrabbit - Users mailing list archive at Nabble.com.
>
>

Mime
View raw message