android - google app engine - Portion of expression could not be parsed -


i want fetch category data google app engine data store except 1 particular category.

for query in apimethod goes :

query query = mgr                 .createquery("select c iconcategorymaster c c.categoryispurchased = :ispurchased , c.categoryname != :catname order c.categoryname,c.categorytype desc");         query.setparameter("ispurchased", true);         query.setparameter("catname", "templateicons");

when try execute api, getting exception below :

com.google.api.server.spi.systemservice invokeservicemethod: portion of expression not parsed: != :catname portion of expression not parsed: != :catname org.datanucleus.store.query.querycompilersyntaxexception: portion of expression not parsed: != :catname     @ org.datanucleus.query.compiler.jpqlparser.parse(jpqlparser.java:77)     @ org.datanucleus.query.compiler.javaquerycompiler.compilefilter(javaquerycompiler.java:466)     @ org.datanucleus.query.compiler.jpqlcompiler.compile(jpqlcompiler.java:81)     @ org.datanucleus.store.query.abstractjpqlquery.compileinternal(abstractjpqlquery.java:271)     @ org.datanucleus.store.query.query.setimplicitparameter(query.java:799)     @ org.datanucleus.api.jpa.jpaquery.setparameter(jpaquery.java:437)     @ org.datanucleus.api.jpa.jpaquery.setparameter(jpaquery.java:57)     @ com.wallpapermaker.keepcalm.iconmasterendpoint.getallicons(iconmasterendpoint.java:228)     @ sun.reflect.nativemethodaccessorimpl.invoke0(native method)     @ sun.reflect.nativemethodaccessorimpl.invoke(nativemethodaccessorimpl.java:57)     @ sun.reflect.delegatingmethodaccessorimpl.invoke(delegatingmethodaccessorimpl.java:43)     @ java.lang.reflect.method.invoke(method.java:45)     @ com.google.api.server.spi.systemservice.invokeservicemethod(systemservice.java:359)     @ com.google.api.server.spi.systemserviceservlet.execute(systemserviceservlet.java:160)     @ com.google.api.server.spi.systemserviceservlet.dopost(systemserviceservlet.java:118)     @ javax.servlet.http.httpservlet.service(httpservlet.java:637)     @ javax.servlet.http.httpservlet.service(httpservlet.java:717)     @ org.mortbay.jetty.servlet.servletholder.handle(servletholder.java:511)     @ org.mortbay.jetty.servlet.servlethandler$cachedchain.dofilter(servlethandler.java:1166)     @ org.mortbay.jetty.servlet.servlethandler$cachedchain.dofilter(servlethandler.java:1157)     @ org.mortbay.jetty.servlet.servlethandler$cachedchain.dofilter(servlethandler.java:1157)     @ org.mortbay.jetty.servlet.servlethandler$cachedchain.dofilter(servlethandler.java:1157)     @ org.mortbay.jetty.servlet.servlethandler$cachedchain.dofilter(servlethandler.java:1157)     @ org.mortbay.jetty.servlet.servlethandler.handle(servlethandler.java:388)     @ org.mortbay.jetty.security.securityhandler.handle(securityhandler.java:216)     @ org.mortbay.jetty.servlet.sessionhandler.handle(sessionhandler.java:182)     @ org.mortbay.jetty.handler.contexthandler.handle(contexthandler.java:765)     @ org.mortbay.jetty.webapp.webappcontext.handle(webappcontext.java:418)     @ org.mortbay.jetty.handler.handlerwrapper.handle(handlerwrapper.java:152)     @ org.mortbay.jetty.server.handle(server.java:326)     @ org.mortbay.jetty.httpconnection.handlerequest(httpconnection.java:542)     @ org.mortbay.jetty.httpconnection$requesthandler.headercomplete(httpconnection.java:923)     @ org.mortbay.jetty.httpconnection.handle(httpconnection.java:404)     @ com.google.tracing.tracecontext$tracecontextrunnable.runincontext(tracecontext.java:438)     @ com.google.tracing.tracecontext$tracecontextrunnable$1.run(tracecontext.java:445)     @ com.google.tracing.currentcontext.runincontext(currentcontext.java:220)     @ com.google.tracing.tracecontext$abstracttracecontextcallback.runininheritedcontextnounref(tracecontext.java:309)     @ com.google.tracing.tracecontext$abstracttracecontextcallback.runininheritedcontext(tracecontext.java:301)     @ com.google.tracing.tracecontext$tracecontextrunnable.run(tracecontext.java:442)     @ java.lang.thread.run(thread.java:724)

can me on why getting such exception , going wrong? thank you.

is != operator in supported query language? see <> might there, @ least according source of parser, not know if != is.

when read list of operators in reference documentation jpql, not see != among them.


Comments

Post a Comment

Popular posts from this blog

php - Submit Form Data without Reloading page -

i know question has been asked , answered bunch of times life of me can not solution work on code. believe if redo code, work properly, , in retrospect time i've spent on issue should have redone code...but beyond deadline , have working prototype up... can advise how update multiple forms on single page without reloading page? horrible @ php , complete noob js/jquery/ajax @ best. html/php in single file , believe causing me problems/is largest obstacle @ getting ajax form processing work. basically, want users to: select teams multiple dropdowns in form group 1 (league champs) , on update update db newly selected team without reloadding page. edit team scores per match , on score submit/update, update db new scores. for each requirement there multiple forms (1 each leagues, 1 each per match) have set class on each form id. everything works via php, form submission reloads page each time submitted , not ideal. i have tried ajax code here http://scotch.io/tutoria...
Read more

linux - Rails running on virtual machine in Windows -

the reason why want switch ubuntu people said gems works better on linux on windows. i don't want macbook pro rails development since love windows , cannot stand lack of apps mac. moreover, people saying ubuntu "better" mac: http://www.reddit.com/r/ubuntu/comments/1bgj1s/are_there_advantages_of_ubuntu_over_os_x_for/ does virtual box work enough doesn't have lag @ all? using i7-3517u cpu 8gb memory. need program in environment lag-free , not sluggish. or there alternatives recommend? i unsure permission settings or complicated stuffs regarding terminal. i'll using terminal develop. i'm still quite new here development in linux. please kind me >< thanks. @holyxiaoxin pretty sure should asking on superuser instead. nevertheless, suggest install ubuntu in partition instead of running virtual machine. here's guide https://help.ubuntu.com/community/windowsdualboot also, yes. developing in virtual machine accurate, @ end experiment w...
Read more