Thanks for your answer! My current code uses query.setFirstResult(n), is this still limited to 1000? Your link is rather old and covers Python, but I would like to use JPA with Java. Do I have to use JDO or will JPA drop the 1000 records limit later?
Regards, On 15 Feb., 05:31, Timofey Koolin <[email protected]> wrote: > Offset get all records from datastore, than skip first n records. > > You can try to readhttp://code.google.com/appengine/articles/paging.html > > On Feb 15, 12:02 am, mjustin <[email protected]> wrote: > > > My application uses JPA and I see the same errors as in version 1.3.0 > > now. > > > If I count records in a table which has more than 1000 entries, the > > result is 1000. > > > If I try to start a Query at an offset > 1000, this error occurs: > > > Caused by: java.lang.IllegalArgumentException: offset may not be above > > 1000 > > at > > com.google.appengine.api.datastore.DatastoreApiHelper.translateError(Datast > > oreApiHelper.java: > > 33) > > at > > com.google.appengine.api.datastore.DatastoreApiHelper.makeSyncCall(Datastor > > eApiHelper.java: > > 60) > > at > > com.google.appengine.api.datastore.PreparedQueryImpl.runQuery(PreparedQuery > > Impl.java: > > 115) > > at > > com.google.appengine.api.datastore.PreparedQueryImpl.asQueryResultList(Prep > > aredQueryImpl.java: > > 75) > > at > > org.datanucleus.store.appengine.query.DatastoreQuery.fulfillEntityQuery(Dat > > astoreQuery.java: > > 359) > > at > > org.datanucleus.store.appengine.query.DatastoreQuery.executeQuery(Datastore > > Query.java: > > 269) > > at > > org.datanucleus.store.appengine.query.DatastoreQuery.performExecute(Datasto > > reQuery.java: > > 228) > > at > > org.datanucleus.store.appengine.query.JPQLQuery.performExecute(JPQLQuery.ja > > va: > > 77) > > at org.datanucleus.store.query.Query.executeQuery(Query.java:1489) > > at org.datanucleus.store.query.Query.executeWithMap(Query.java:1398) > > at org.datanucleus.jpa.JPAQuery.getResultList(JPAQuery.java:163) > > > Does this mean only the native API and JDO can use more than 1000 > > records in a query? > > > Regards, > > -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
