jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Gadbury <gadb...@googlemail.com>
Subject SQL2 Column Selector bug?
Date Thu, 11 Mar 2010 12:36:36 GMT

Hi all,

I am preparing and executing an SQL2 query (JCR 2.0) as follows:

QueryManager qm = jcrSession.getWorkspace().getQueryManager();			
String queryString = "select order.[customerAccountUUID] as cust from
[atl:order] as order";
Query query = qm.createQuery(queryString, Query.JCR_SQL2); 
QueryResult queryResult = query.execute();

I have been using the test case (here:
http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-spi-commons/src/test/resources/org/apache/jackrabbit/spi/commons/query/sql2/test.sql2.txt?view=markup)
as a guideline.

The following query fails:

select order.[customerAccountUUID] from [atl:order] as order

java.lang.NullPointerException

org.apache.jackrabbit.commons.query.sql2.QOMFormatter.isSimpleName(QOMFormatter.java:577)

org.apache.jackrabbit.commons.query.sql2.QOMFormatter.formatName(QOMFormatter.java:567)

org.apache.jackrabbit.commons.query.sql2.QOMFormatter.format(QOMFormatter.java:452)

org.apache.jackrabbit.commons.query.sql2.QOMFormatter.format(QOMFormatter.java:123)

org.apache.jackrabbit.commons.query.sql2.QOMFormatter.format(QOMFormatter.java:117)

line 452: c.getColumnName() returns null.

The following query is fine:

select order.[customerAccountUUID] as cust from [atl:order] as order

The test case suggests that I do not need the 'as cust' for the column
select, so should the failing sql work?

Cheers,

James
-- 
View this message in context: http://n4.nabble.com/SQL2-Column-Selector-bug-tp1588881p1588881.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Mime
View raw message