Simple JCR_SQL2 query returns nothing on Jackrabbit 2.1.1

Hi,

I have this simple JCR_SQL2 query:
SELECT * FROM [my:type]

I'm running it like so:

final QueryManager qMan = session.getWorkspace().getQueryManager();
final Query q = qMan.createQuery("SELECT * FROM [my:type]", Query.JCR_SQL2);
final QueryResult qResult = q.execute();
return qResult.getNodes();

on a workspace which is indexed (according to the configuration). This is the workspace search index configuration (I really hope it is wrong ... ):

    <SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
        <param name="path" value="${wsp.home}/index"/>
        <param name="supportHighlighting" value="true"/>
    </SearchIndex>

I'm 100% sure that there are nodes of that type in the workspace currently. So my problem is that the NodeIterator returned by the QueryResult is 'empty'.

And my question is do you see anything wrong with the configuration/query ? Or can you think of something I'm missing ?

Thanks.

ansaurus

tags:

views:

answers:

Simple JCR_SQL2 query returns nothing on Jackrabbit 2.1.1

related questions