From jackrabbit-dev-return-987-apmail-incubator-jackrabbit-dev-archive=www.apache.org@incubator.apache.org Mon Mar 07 10:04:03 2005 Return-Path: Delivered-To: apmail-incubator-jackrabbit-dev-archive@www.apache.org Received: (qmail 36560 invoked from network); 7 Mar 2005 10:04:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur-2.apache.org with SMTP; 7 Mar 2005 10:04:03 -0000 Received: (qmail 68257 invoked by uid 500); 7 Mar 2005 10:04:02 -0000 Mailing-List: contact jackrabbit-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jackrabbit-dev@incubator.apache.org Delivered-To: mailing list jackrabbit-dev@incubator.apache.org Received: (qmail 68242 invoked by uid 99); 7 Mar 2005 10:04:02 -0000 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=FORGED_RCVD_HELO,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: domain of marcel.reutegger@gmx.net designates 213.165.64.20 as permitted sender) Received: from mail.gmx.de (HELO mail.gmx.net) (213.165.64.20) by apache.org (qpsmtpd/0.28) with SMTP; Mon, 07 Mar 2005 02:04:00 -0800 Received: (qmail invoked by alias); 07 Mar 2005 10:03:57 -0000 Received: from bsl-rtr.day.com (EHLO [10.0.0.66]) (212.249.34.130) by mail.gmx.net (mp022) with SMTP; 07 Mar 2005 11:03:57 +0100 X-Authenticated: #894343 Message-ID: <422C270D.2060401@gmx.net> Date: Mon, 07 Mar 2005 11:03:57 +0100 From: Marcel Reutegger User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: jackrabbit-dev@incubator.apache.org Subject: Re: JCR API question References: <422BA14A.8070803@gmail.com> In-Reply-To: <422BA14A.8070803@gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Checked: Checked X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi Edgar, Edgar Poce wrote: > Hi > In the specification doc 0.16.2 the following methods are defined for > QueryResult: QueryResult.getPropertyNames(), QueryResult.getRows() and > QueryResult.getNodes() (page 110). But in the page 112 it says "The > column names of the table are returned by QueryResult.getColumnNames". > it should say getPropertyNames(), or am I missing something? yes, that's definitively an error in the spec. thanks for reporting this. > in 8.6.3 SQL EBNF it says > "select ::= SELECT ('*' | proplist )" > So it seems jcr doesn't support any kind of expression nor function in > the select clause. > e.g. something like "SELECT concat(myapp:myprop1, myapp:myprop2) as > customColumn from myapp:mynodetype" would be really handy. And it could > be retrieved with QueryResult.getColumnName("customColumn"). What do you > think? while this would work fine in SQL, there is no equivalent in XPath, and that's the reason why such a function is not specified. The EG decided to make the mandatory part of the two specified query langages interchangeable, that is, each SQL query must also be expressible in XPath and vice versa. However implementations are of course free to support more than only the mandatory specified part. I personally think it is a good approach to start with a common feature set and then gain experience what jsr-170 applications demand from the query support, which then can be used to drive the next version of the spec. Maybe it makes sense to start some kind of wishlist for jackrabbit where we can pool all the ideas around new features and extensions? regards marcel