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 <[email protected]> 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. > >
