Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: local policy)
From: Blanco Emanuele <e.blanco@reply.it>
To: "users@jackrabbit.apache.org" <users@jackrabbit.apache.org>
Date: Thu, 13 Nov 2008 15:40:14 +0100
Subject: SQL case insensitive search using jcr:path
Thread-Topic: SQL case insensitive search using jcr:path
Thread-Index: AclFnb0Hm1btKBRtSJuIE8ORLrSfGg==
Message-ID: 
 <9889CC1A69BBC549931AF0B0C250EE65127968AFA2@CED01CMBXS01.replynet.prv>
Accept-Language: it-IT, en-US
Content-Language: en-US
acceptlanguage: it-IT, en-US
Content-Type: multipart/alternative;
	boundary="_000_9889CC1A69BBC549931AF0B0C250EE65127968AFA2CED01CMBXS01r_"
MIME-Version: 1.0

--_000_9889CC1A69BBC549931AF0B0C250EE65127968AFA2CED01CMBXS01r_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I'm trying to write some SQL queries to search nodes in my Jackrabbit repos=
itory. I need to find nodes, given the node name, under a specified path.

I used something like this (assuming I need to search for a node named 'foo=
bar' in descendants of /foo/bar):

SELECT * FROM ns:type WHERE jcr:path LIKE '/foo/bar/%/foobar'

However, if the node is stored as FOOBAR, Foobar, fooBar or so on, searchin=
g will not return any result. Is there a way to make this search case insen=
sitive?

And, last but not least, there is a way to specify a "soundslike" concept, =
always using jcr:path?

Thank you.

--
Emanuele Blanco

________________________________
--
The information transmitted is intended for the person or entity to which i=
t is addressed and may contain confidential and/or privileged material. Any=
 review, retransmission, dissemination or other use of, or taking of any ac=
tion in reliance upon, this information by persons or entities other than t=
he intended recipient is prohibited. If you received this in error, please =
contact the sender and delete the material from any computer.

--_000_9889CC1A69BBC549931AF0B0C250EE65127968AFA2CED01CMBXS01r_--