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

Reply via email to