Cayenne 3.0.M5 fetch offset

From: Marco Gattei (marco.gatte..mail.com)
Date: Fri Apr 24 2009 - 05:00:22 EDT

  • Next message: Aristedes Maniatis: "Re: Cayenne 3.0.M5 fetch offset"

    Hi everyone,

        a newbie question .... Is fetchOffset supported on Sybase ?

    i did some test with cayennne 3 with SelectQuery and fetch offset and
    running code like this:
     
            SelectQuery query = new SelectQuery(MyClass.class,
    e.expWithParameters(parametri));
            query.setFetchOffset(10);
            query.setFetchLimit(10);
            List<MyClass> list = performQuery(query);

    on oracle returns only 10 items in the list ....
    on sybase returns 2000 items !!!!!

    I'm missing something ?

    Thank you

    Marco

    This archive was generated by hypermail 2.0.0 : Fri Apr 24 2009 - 05:01:09 EDT