Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (nike.apache.org: domain of tmueller@day.com designates
 207.126.148.88 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <442569030911020628g20746680ob8978bf5a9360c6c@mail.gmail.com>
References: <442569030911020628g20746680ob8978bf5a9360c6c@mail.gmail.com>
Date: Mon, 2 Nov 2009 16:04:13 +0100
Message-ID: <91f3b2650911020704x11d4d3c2y25bf322379d08da8@mail.gmail.com>
Subject: Re: BindVariable in JCR-SQL2 CONTAINS
From: =?ISO-8859-1?Q?Thomas_M=FCller?= <thomas.mueller@day.com>
To: users@jackrabbit.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I'm not sure, but it looks like a bug in Jackrabbit. The statement
seems to be parsed correctly, but extracting the bind variables
doesn't pick it up. Could you file a Jira bug report please? Just copy
& paste the example code below, that's enough to reproduce the issue.

Regards,
Thomas


On Mon, Nov 2, 2009 at 3:28 PM, Philipp Bunge <buge@crimson.ch> wrote:
> Hi
>
> I'm trying to use the following FullTextSearch query in Jackrabbit 2.0 beta1:
> Query query = qm.createQuery("SELECT * FROM [my:document] AS document
> WHERE CONTAINS(document.original, $x)", Query.JCR_SQL2);
>
> But the following fails with a "java.lang.IllegalArgumentException:
> not a valid variable in this query:"
> query.bindVariable("x", vf.createValue("moo"));
>
> In fact, query.getBindVariableNames() returns an empty array.
>
> Did I miss something?
>
> Thanks in advance,
> Philipp
>