Hi Nick,
The id field was from the examples. Anyway, was trying to remove the
old index but without success (no remove in Java SDK, and no success
with the Python SDK either). Right now I have both the old and the new
index running on the server (the new one is just the old one with id
removed) so perhaps there may be conflicts.
Or should I just create a totally new class name with the right fields
and build the index on those new classes for now until the Java vacuum
index is ready?
Best,
Tommy
On 7月7日, 下午9時54分, "Nick Johnson (Google)" <nick.john...@google.com>
wrote:
> Hi GArchitect,
>
> The index you list isn't suitable for that query - the index includes
> the 'id' field at the start, but you don't appear to be filtering or
> sorting on it.
>
> -Nick Johnson
>
>
>
> On Mon, Jul 6, 2009 at 4:28 AM, GArchitect<tommy...@gmail.com> wrote:
>
> > Hi, I got the following exception in a method executing a query:
>
> > C 07-05 07:23PM 42.069
> > Uncaught exception from servlet
> > com.google.appengine.api.datastore.DatastoreNeedIndexException: no
> > matching index found.
> > at
> > com.google.appengine.api.datastore.DatastoreApiHelper.translateError
> > (DatastoreApiHelper.java:34)
> > at com.google.appengine.api.datastore.DatastoreApiHelper.makeSyncCall
> > (DatastoreApiHelper.java:55)
> > at com.google.appengine.api.datastore.DatastoreServiceImpl
> > $PreparedQueryImpl.runQuery(DatastoreServiceImpl.java:310)
> > at com.google.appengine.api.datastore.DatastoreServiceImpl
> > $PreparedQueryImpl.access$100(DatastoreServiceImpl.java:240)
> > at com.google.appengine.api.datastore.DatastoreServiceImpl
> > $PreparedQueryImpl$1.iterator(DatastoreServiceImpl.java:269)
> > at
> > org.datanucleus.store.appengine.query.RuntimeExceptionWrappingIterable.iterator
> > (RuntimeExceptionWrappingIterable.java:42)
> > at org.datanucleus.store.appengine.query.StreamingQueryResult.<init>
> > (StreamingQueryResult.java:72)
> > at
> > org.datanucleus.store.appengine.query.DatastoreQuery.fulfillEntityQuery
> > (DatastoreQuery.java:253)
> > at
> > org.datanucleus.store.appengine.query.DatastoreQuery.performExecute
> > (DatastoreQuery.java:220)
> > at org.datanucleus.store.appengine.query.JDOQLQuery.performExecute
> > (JDOQLQuery.java:85)
> > at org.datanucleus.store.appengine.query.JDOQLQuery.performExecute
> > (JDOQLQuery.java:31)
> > at org.datanucleus.store.query.Query.executeQuery(Query.java:1466)
> > at org.datanucleus.store.query.Query.executeWithArray(Query.java:
> > 1340)
> > at org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:240)
> > at
> > com.solveware.gwt.sample.stockwatcher.server.HistoricalQuote.getAllQuotesOnSymbol
> > (HistoricalQuote.java:130)
> > ...
>
> > However, according to the admin console, the required index is up and
> > running
>
> > HistoricalQuote
> > id ▲ , symbol ▲ , date ▲ Serving
>
> > And the code for executing the query:
>
> > public static List<HistoricalQuote> getAllQuotesOnSymbol(String
> > symbol) {
> > PersistenceManager pm =
> > PMF.get().getPersistenceManager();
> > Query query = pm.newQuery(HistoricalQuote.class);
> > query.setFilter("symbol == userSubmittedSymbol");
> > query.setOrdering("date ASC");
> > query.declareParameters("String userSubmittedSymbol");
> > List<HistoricalQuote> entries = (List<HistoricalQuote>)
> > query.execute(symbol);
> > return entries;
> > }
>
> > So I wonder if anyone can shed some light on why this is happening?
> > Is it a problem on the GAE side that is waiting to be fixed?
>
> > Any help is appreciated. Thanks.
>
> > Best,
>
> > Tommy
>
> --
> Nick Johnson, App Engine Developer Programs Engineer
> Google Ireland Ltd. :: Registered in Dublin, Ireland, Registration
> Number: 368047
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~----------~----~----~----~------~----~------~--~---
