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 <[email protected]>wrote: > On Fri, Jan 29, 2010 at 13:47, Jacco van Weert <[email protected]> > 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 > [email protected] > -- ------------------------------------- Jacco van Weert -- [email protected] JCR Controller -- http://www.xs4all.nl/~weertj/jcr JeCARS -- http://kenai.com/projects/jecars
