Groups > comp.lang.java.programmer > #39178

Re: JCR ModeShape non-existant column 'mode:localName'

Path	csiph.com!weretis.net!feeder6.news.weretis.net!feeder7.news.weretis.net!news.mixmin.net!aioe.org!.POSTED.O5hsyUvK01te0L/SZurVSQ.user.gioia.aioe.org!not-for-mail
From	Arne Vajhøj <arne@vajhoej.dk>
Newsgroups	comp.lang.java.programmer
Subject	Re: JCR ModeShape non-existant column 'mode:localName'
Date	Sun, 17 Nov 2019 20:00:09 -0500
Organization	Aioe.org NNTP Server
Lines	47
Message-ID	<qqsqeo$g1r$1@gioia.aioe.org> (permalink)
References	<qn8ql6$11c4$1@gioia.aioe.org>
NNTP-Posting-Host	O5hsyUvK01te0L/SZurVSQ.user.gioia.aioe.org
Mime-Version	1.0
Content-Type	text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding	8bit
X-Complaints-To	abuse@aioe.org
User-Agent	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:60.0) Gecko/20100101 Thunderbird/60.9.1
Content-Language	en-US
X-Notice	Filtered by postfilter v. 0.9.2
Xref	csiph.com comp.lang.java.programmer:39178

Show key headers only | View raw

On 10/4/2019 9:12 PM, Arne Vajhøj wrote:
> I am playing a little bit with JCR.
> 
> I have this piece of code doing a JCR SQL2 query:
> 
> Query q = ses.getWorkspace().getQueryManager().createQuery("SELECT 
> author,time,title,body FROM [nt:unstructured] WHERE author = '" + author 
> + "' AND title IS NOT NULL", Query.JCR_SQL2);
> QueryResult q1 = q.execute();
> 
> When using JackRabbit as implementation it works.
> 
> When using ModeShape as implementation then execute gives me:
> 
> Exception in thread "main" 
> org.modeshape.jcr.query.parse.InvalidQueryException: The view references 
> a non-existant column 'mode:localName' in '__ALLNODES__'
> 
> I tried both version 5.4.1 and 4.6.2 - same exception in both.
> 
> It is documented that ModeShape use a pseudo property/column
> mode:localName.
> 
> https://docs.jboss.org/author/display/MODE50/Query+and+search
> 
> <quote>
> ModeShape adds support for several columns that don't really exist on 
> any node types but that are implicit in JCR. You can use these columns 
> anywhere in a query that columns can normally be used.
> ...
> mode:localName     The local name of the node. The value is equivalent 
> to jcr:name except without the namespace portion of the name.
> </quote>
> 
> So it is supposed to be there.
> 
> But per exception message it is not.
> 
> And furthermore I am not trying to use it (explicitly).

Problem went away when I stopped using namespace in
node names.

What can I say.

Arne

Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

JCR ModeShape non-existant column 'mode:localName' Arne Vajhøj <arne@vajhoej.dk> - 2019-10-04 21:12 -0400
  Re: JCR ModeShape non-existant column 'mode:localName' Arne Vajhøj <arne@vajhoej.dk> - 2019-11-17 20:00 -0500

csiph-web