jackrabbit-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lukas Kahwe Smith (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (JCR-3089) javax.jcr.RepositoryException when trying to run an SQL2 query via Davex
Date Fri, 30 Sep 2011 12:00:46 GMT
javax.jcr.RepositoryException when trying to run an SQL2 query via Davex
------------------------------------------------------------------------

                 Key: JCR-3089
                 URL: https://issues.apache.org/jira/browse/JCR-3089
             Project: Jackrabbit Content Repository
          Issue Type: Bug
            Reporter: Lukas Kahwe Smith


see the following thread for details:
http://www.mail-archive.com/users@jackrabbit.apache.org/msg17975.html

DavexClient Client = new DavexClient(url);
Repository repo = Client.getRepository();
Credentials sc = new SimpleCredentials("admin","admin".toCharArray());
Session s = repo.login(sc,workspace);

QueryManager qm = s.getWorkspace().getQueryManager();

String sql = "SELECT data.* FROM [nt:unstructured] AS data WHERE data.lala= 'huii'";
sql = "SELECT * FROM [nt:unstructured] AS data INNER JOIN [nt:unstructured] AS referring ON
referring.[dong] = data.[jcr:uuid] WHERE data.lala = 'huii'";
sql = "SELECT * FROM [nt:unstructured] AS data INNER JOIN [nt:unstructured] AS referring ON
ISDESCENDANTNODE(data, referring) WHERE data.lala = 'huii'";
Query query = qm.createQuery(sql, Query.JCR_SQL2);
QueryResult qr = query.execute();

The first query works just fine and I can iterate over the result. Neither the second nor
the third query works.
In both cases I end up with a javax.jcr.RepositoryException

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message