You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by Alexander Klimetschek <ak...@day.com> on 2010/02/01 14:23:07 UTC
Re: SQL in Jackrabbit 2.0
On Fri, Jan 29, 2010 at 13:47, Jacco van Weert <11...@gmail.com> wrote:
> I am testing the Jackrabbit 2.0 release and I am running into a SQL problem.
> For some reason all my SQL queries are returning with no results. When using
> Jackrabbit 1.6 they do.
>
> I know SQL is deprecated but it should still work, right?
Yes, xpath and sql as in JCR 1.0 should still be supported by
Jackrabbit 2.0. This must be a specific issue/bug then.
Regards,
Alex
--
Alexander Klimetschek
alexander.klimetschek@day.com
Re: SQL in Jackrabbit 2.0
Posted by Jacco van Weert <11...@gmail.com>.
Hello,
I use the following query:
SELECT * FROM jecars:root WHERE jecars:ExpireDate<= TIMESTAMP
'2010-02-15T13:41:53.641+01:00'
With Jackrabbit v1.6 it delivers a result as expected.
With Jackrabbit v2.0 the QueryResult.getNodes() returns -1.
gr.
Jacco
On Mon, Feb 1, 2010 at 2:23 PM, Alexander Klimetschek <ak...@day.com>wrote:
> On Fri, Jan 29, 2010 at 13:47, Jacco van Weert <11...@gmail.com>
> wrote:
> > I am testing the Jackrabbit 2.0 release and I am running into a SQL
> problem.
> > For some reason all my SQL queries are returning with no results. When
> using
> > Jackrabbit 1.6 they do.
> >
> > I know SQL is deprecated but it should still work, right?
>
> Yes, xpath and sql as in JCR 1.0 should still be supported by
> Jackrabbit 2.0. This must be a specific issue/bug then.
>
> Regards,
> Alex
>
> --
> Alexander Klimetschek
> alexander.klimetschek@day.com
>
--
-------------------------------------
Jacco van Weert -- 1111software@gmail.com
JCR Controller -- http://www.xs4all.nl/~weertj/jcr
JeCARS -- http://kenai.com/projects/jecars