Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Date: Mon, 11 Apr 2011 16:53:05 +0000 (UTC)
From: "Alex Parvulescu (JIRA)" <jira@apache.org>
To: dev@jackrabbit.apache.org
Message-ID: 
 <521492332.49485.1302540785793.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <1561380965.49431.1302539946291.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Updated] (JCR-2939) QueryObjectModel does not generate the
 corresponding SQL2 Query when dealing with spaces in the path
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/JCR-2939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Alex Parvulescu updated JCR-2939:
---------------------------------

    Attachment: JCR-2939.patch

attached patch to fix and some tests

> QueryObjectModel does not generate the corresponding SQL2 Query when dealing with spaces in the path
> ----------------------------------------------------------------------------------------------------
>
>                 Key: JCR-2939
>                 URL: https://issues.apache.org/jira/browse/JCR-2939
>             Project: Jackrabbit Content Repository
>          Issue Type: Improvement
>            Reporter: Alex Parvulescu
>            Priority: Minor
>         Attachments: JCR-2939.patch
>
>
> This is the original issue:
> ----------
> I tried to get the childnodes of a node names "/a b" using the following code
>   QueryManager queryManager=session.getWorkspace().getQueryManager();
>   QueryObjectModelFactory qomf=queryManager.getQOMFactory();
>   Source source1=qomf.selector(NodeType.NT_BASE, "selector_0");
>   Column[] columns = new Column[]{qomf.column("selector_0", null, null)};
>   Constraint constraint2 = qomf.childNode("selector_0", "/a b");
>   QueryObjectModel qom = qomf.createQuery(source1, constraint2 , null, columns);
> This is not giving any result when the session is acquired through webdav. But when connected using JNDI it is giving the child nodes. 
> The sql statement getting created is 
> SELECT selector_0.* FROM [nt:base] AS selector_0 WHERE ISCHILDNODE(selector_0, 
> [/a b]).
> When using webdav If i give this SQL2 query directly along with quotes around 
> the path i.e. ['/a b'] then it is working as expected.
> ----------
> this doesn't have anything to do with webdav. the problem is the QueryObjectModel generates an SQL2 query that is not 100% equivalent, it fails to escape paths that have spaces in them.
> this way, in the case of davex remoting, the jr client will use the statement generated instead, which is not escaped, and will fail to return the expected nodes. 
> This can be seen easily if we do a System.out.println(qom.getStatement())

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira