android - JPA query not returning results when run in remote server -

android - JPA query not returning results when run in remote server -

i developing android app app engine backend. when run backend application in remote server, , query entities using jpql query, below, returns no results.

querystring= "select item i.locationid= :locid order i.itemquantity"; query q = mgr.createquery(querystring); q.setparameter("locid", location);

however, same query when run in local development server, returns results.

another observation: if remove parameters , maintain query simple order statement, returns results both in dev server , in remote run.

for complex queries need define explicit composite index.

local dev server builds on fly, while on production server need define composite indexes explicitly.

for simple queries, e.g. order by, composite index not necessary, expected result.

android jpa google-app-engine