jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jacco van Weert <1111softw...@gmail.com>
Subject Re: SQL in Jackrabbit 2.0
Date Mon, 15 Feb 2010 12:45:13 GMT
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 <aklimets@day.com>wrote:

> On Fri, Jan 29, 2010 at 13:47, Jacco van Weert <1111software@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message