mysql - jpql with WHERE statement = SQL sintax error -
i have problem jpql... i'm trying create web app vaadin, shiro, mysql, jpa... have made desktop app few years ago , utilize libs jpa project. have problem mysql-connector-java-5.0.8-bin.jar. when seek run project become sql exception com.mysql.jdbc.driver not found. few people had same problem , solved replacing mysql connector 5.0.8 5.1.17 or higher. made , have new problem queries.
this query works fine :
typedquery<products> q = em.createquery("select e products e",products.class); list<products> products = q.getresultlist(); this query doesn't work fine :
typedquery<products> q = em.createquery("select e products e e.name 'something'",products.class); products products = q.getsingleresult(); i become exception:
15:45:25,879 info [stdout] (http-localhost-127.0.0.1-8080-1) hibernate: 15:45:25,879 info [stdout] (http-localhost-127.0.0.1-8080-1) query (select 15:45:25,880 info [stdout] (http-localhost-127.0.0.1-8080-1) product0_.idproduct idproduct_495_, 15:45:25,880 info [stdout] (http-localhost-127.0.0.1-8080-1) product0_.name name495_, 15:45:25,904 info [stdout] (http-localhost-127.0.0.1-8080-1) row_number() on ( 15:45:25,905 info [stdout] (http-localhost-127.0.0.1-8080-1) order 15:45:25,905 info [stdout] (http-localhost-127.0.0.1-8080-1) current_timestamp) __hibernate_row_nr__ 15:45:25,905 info [stdout] (http-localhost-127.0.0.1-8080-1) 15:45:25,905 info [stdout] (http-localhost-127.0.0.1-8080-1) products product0_ 15:45:25,906 info [stdout] (http-localhost-127.0.0.1-8080-1) 15:45:25,906 info [stdout] (http-localhost-127.0.0.1-8080-1) product0_.name 'something') select 15:45:25,906 info [stdout] (http-localhost-127.0.0.1-8080-1) * 15:45:25,907 info [stdout] (http-localhost-127.0.0.1-8080-1) 15:45:25,907 info [stdout] (http-localhost-127.0.0.1-8080-1) query 15:45:25,907 info [stdout] (http-localhost-127.0.0.1-8080-1) 15:45:25,907 info [stdout] (http-localhost-127.0.0.1-8080-1) __hibernate_row_nr__ >= ? 15:45:25,908 info [stdout] (http-localhost-127.0.0.1-8080-1) , __hibernate_row_nr__ < ? 15:45:25,924 warn [org.hibernate.engine.jdbc.spi.sqlexceptionhelper] (http-localhost-127.0.0.1-8080-1) sql error: 1064, sqlstate: 42000 15:45:25,924 error [org.hibernate.engine.jdbc.spi.sqlexceptionhelper] (http-localhost-127.0.0.1-8080-1) have error in sql syntax; check manual corresponds mysql server version right syntax utilize near 'with query (select product0_.idproduct idproduct_495_, product0_' @ line 1 15:45:25,926 severe [com.vaadin.server.defaulterrorhandler] (http-localhost-127.0.0.1-8080-1) : javax.persistence.persistenceexception: org.hibernate.exception.sqlgrammarexception: have error in sql syntax; check manual corresponds mysql server version right syntax utilize near 'with query (select product0_.idproduct idproduct_495_, product0_' @ line 1 @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1361) [hibernate-entitymanager-4.0.1.final.jar:4.0.1.final] @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1289) [hibernate-entitymanager-4.0.1.final.jar:4.0.1.final] @ org.hibernate.ejb.queryimpl.getsingleresult(queryimpl.java:313) [hibernate-entitymanager-4.0.1.final.jar:4.0.1.final] @ com.vaadin.demo.dashboard.dashboardui.init(dashboardui.java:105) [classes:] @ com.vaadin.ui.ui.doinit(ui.java:610) [vaadin-server-7.1.6.jar:7.1.6] @ com.vaadin.server.communication.uiinithandler.getbrowserdetailsui(uiinithandler.java:223) [vaadin-server-7.1.6.jar:7.1.6] @ com.vaadin.server.communication.uiinithandler.synchronizedhandlerequest(uiinithandler.java:73) [vaadin-server-7.1.6.jar:7.1.6] @ com.vaadin.server.synchronizedrequesthandler.handlerequest(synchronizedrequesthandler.java:37) [vaadin-server-7.1.6.jar:7.1.6] @ com.vaadin.server.vaadinservice.handlerequest(vaadinservice.java:1371) [vaadin-server-7.1.6.jar:7.1.6] @ com.vaadin.server.vaadinservlet.service(vaadinservlet.java:238) [vaadin-server-7.1.6.jar:7.1.6] @ javax.servlet.http.httpservlet.service(httpservlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.final.jar:1.0.0.final] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:329) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:248) [jbossweb-7.0.13.final.jar:] @ org.jboss.weld.servlet.conversationpropagationfilter.dofilter(conversationpropagationfilter.java:62) [weld-core-1.1.5.as71.final.jar:2012-02-10 15:31] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:280) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:248) [jbossweb-7.0.13.final.jar:] @ org.apache.shiro.web.servlet.abstractshirofilter.executechain(abstractshirofilter.java:449) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.web.servlet.abstractshirofilter$1.call(abstractshirofilter.java:365) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.subject.support.subjectcallable.docall(subjectcallable.java:90) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.subject.support.subjectcallable.call(subjectcallable.java:83) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.subject.support.delegatingsubject.execute(delegatingsubject.java:383) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.web.servlet.abstractshirofilter.dofilterinternal(abstractshirofilter.java:362) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.web.servlet.onceperrequestfilter.dofilter(onceperrequestfilter.java:125) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:280) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:248) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:275) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:161) [jbossweb-7.0.13.final.jar:] @ org.jboss.as.jpa.interceptor.webnontxemcloservalve.invoke(webnontxemcloservalve.java:50) [jboss-as-jpa-7.1.1.final.jar:7.1.1.final] @ org.jboss.as.web.security.securitycontextassociationvalve.invoke(securitycontextassociationvalve.java:153) [jboss-as-web-7.1.1.final.jar:7.1.1.final] @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:155) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:102) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:109) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:368) [jbossweb-7.0.13.final.jar:] @ org.apache.coyote.http11.http11processor.process(http11processor.java:877) [jbossweb-7.0.13.final.jar:] @ org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:671) [jbossweb-7.0.13.final.jar:] @ org.apache.tomcat.util.net.jioendpoint$worker.run(jioendpoint.java:930) [jbossweb-7.0.13.final.jar:] @ java.lang.thread.run(unknown source) [rt.jar:1.7.0_60] caused by: org.hibernate.exception.sqlgrammarexception: have error in sql syntax; check manual corresponds mysql server version right syntax utilize near 'with query (select product0_.idproduct idproduct_495_, product0_' @ line 1 @ org.hibernate.exception.internal.sqlexceptiontypedelegate.convert(sqlexceptiontypedelegate.java:82) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.exception.internal.standardsqlexceptionconverter.convert(standardsqlexceptionconverter.java:47) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:125) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.engine.jdbc.spi.sqlexceptionhelper.convert(sqlexceptionhelper.java:110) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.engine.jdbc.internal.proxy.abstractstatementproxyhandler.continueinvocation(abstractstatementproxyhandler.java:129) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.engine.jdbc.internal.proxy.abstractproxyhandler.invoke(abstractproxyhandler.java:81) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ com.sun.proxy.$proxy53.executequery(unknown source) @ org.hibernate.loader.loader.getresultset(loader.java:1978) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.doquery(loader.java:829) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:289) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.dolist(loader.java:2463) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.dolist(loader.java:2449) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.listignorequerycache(loader.java:2279) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.list(loader.java:2274) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.hql.queryloader.list(queryloader.java:470) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.hql.internal.ast.querytranslatorimpl.list(querytranslatorimpl.java:355) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.engine.query.spi.hqlqueryplan.performlist(hqlqueryplan.java:196) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.internal.sessionimpl.list(sessionimpl.java:1115) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.internal.queryimpl.list(queryimpl.java:101) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.ejb.queryimpl.getsingleresult(queryimpl.java:280) [hibernate-entitymanager-4.0.1.final.jar:4.0.1.final] ... 34 more caused by: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: have error in sql syntax; check manual corresponds mysql server version right syntax utilize near 'with query (product0_.idproduct idproduct_495_, product0_' @ line 1 @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) [rt.jar:1.7.0_60] @ sun.reflect.nativeconstructoraccessorimpl.newinstance(unknown source) [rt.jar:1.7.0_60] @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(unknown source) [rt.jar:1.7.0_60] @ java.lang.reflect.constructor.newinstance(unknown source) [rt.jar:1.7.0_60] @ com.mysql.jdbc.util.handlenewinstance(util.java:411) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.util.getinstance(util.java:386) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1052) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3597) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3529) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:1990) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2151) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2625) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.preparedstatement.executeinternal(preparedstatement.java:2119) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.preparedstatement.executequery(preparedstatement.java:2281) [mysql-connector-java-5.1.17-bin.jar:] @ org.jboss.jca.adapters.jdbc.cachedpreparedstatement.executequery(cachedpreparedstatement.java:107) @ org.jboss.jca.adapters.jdbc.wrappedpreparedstatement.executequery(wrappedpreparedstatement.java:462) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) [rt.jar:1.7.0_60] @ sun.reflect.nativemethodaccessorimpl.invoke(unknown source) [rt.jar:1.7.0_60] @ sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) [rt.jar:1.7.0_60] @ java.lang.reflect.method.invoke(unknown source) [rt.jar:1.7.0_60] @ org.hibernate.engine.jdbc.internal.proxy.abstractstatementproxyhandler.continueinvocation(abstractstatementproxyhandler.java:122) [hibernate-core-4.0.1.final.jar:4.0.1.final] ... 49 more 15:45:25,971 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/dashboard].[vaadinservlet]] (http-localhost-127.0.0.1-8080-1) servlet.service() servlet vaadinservlet threw exception: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: have error in sql syntax; check manual corresponds mysql server version right syntax utilize near 'with query (product0_.idproduct idproduct_495_, product0_' @ line 1 @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) [rt.jar:1.7.0_60] @ sun.reflect.nativeconstructoraccessorimpl.newinstance(unknown source) [rt.jar:1.7.0_60] @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(unknown source) [rt.jar:1.7.0_60] @ java.lang.reflect.constructor.newinstance(unknown source) [rt.jar:1.7.0_60] @ com.mysql.jdbc.util.handlenewinstance(util.java:411) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.util.getinstance(util.java:386) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1052) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3597) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:3529) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:1990) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2151) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2625) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.preparedstatement.executeinternal(preparedstatement.java:2119) [mysql-connector-java-5.1.17-bin.jar:] @ com.mysql.jdbc.preparedstatement.executequery(preparedstatement.java:2281) [mysql-connector-java-5.1.17-bin.jar:] @ org.jboss.jca.adapters.jdbc.cachedpreparedstatement.executequery(cachedpreparedstatement.java:107) @ org.jboss.jca.adapters.jdbc.wrappedpreparedstatement.executequery(wrappedpreparedstatement.java:462) @ sun.reflect.nativemethodaccessorimpl.invoke0(native method) [rt.jar:1.7.0_60] @ sun.reflect.nativemethodaccessorimpl.invoke(unknown source) [rt.jar:1.7.0_60] @ sun.reflect.delegatingmethodaccessorimpl.invoke(unknown source) [rt.jar:1.7.0_60] @ java.lang.reflect.method.invoke(unknown source) [rt.jar:1.7.0_60] @ org.hibernate.engine.jdbc.internal.proxy.abstractstatementproxyhandler.continueinvocation(abstractstatementproxyhandler.java:122) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.engine.jdbc.internal.proxy.abstractproxyhandler.invoke(abstractproxyhandler.java:81) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ com.sun.proxy.$proxy53.executequery(unknown source) @ org.hibernate.loader.loader.getresultset(loader.java:1978) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.doquery(loader.java:829) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.doqueryandinitializenonlazycollections(loader.java:289) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.dolist(loader.java:2463) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.dolist(loader.java:2449) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.listignorequerycache(loader.java:2279) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.loader.list(loader.java:2274) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.loader.hql.queryloader.list(queryloader.java:470) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.hql.internal.ast.querytranslatorimpl.list(querytranslatorimpl.java:355) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.engine.query.spi.hqlqueryplan.performlist(hqlqueryplan.java:196) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.internal.sessionimpl.list(sessionimpl.java:1115) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.internal.queryimpl.list(queryimpl.java:101) [hibernate-core-4.0.1.final.jar:4.0.1.final] @ org.hibernate.ejb.queryimpl.getsingleresult(queryimpl.java:280) [hibernate-entitymanager-4.0.1.final.jar:4.0.1.final] @ com.vaadin.demo.dashboard.dashboardui.init(dashboardui.java:105) [classes:] @ com.vaadin.ui.ui.doinit(ui.java:610) [vaadin-server-7.1.6.jar:7.1.6] @ com.vaadin.server.communication.uiinithandler.getbrowserdetailsui(uiinithandler.java:223) [vaadin-server-7.1.6.jar:7.1.6] @ com.vaadin.server.communication.uiinithandler.synchronizedhandlerequest(uiinithandler.java:73) [vaadin-server-7.1.6.jar:7.1.6] @ com.vaadin.server.synchronizedrequesthandler.handlerequest(synchronizedrequesthandler.java:37) [vaadin-server-7.1.6.jar:7.1.6] @ com.vaadin.server.vaadinservice.handlerequest(vaadinservice.java:1371) [vaadin-server-7.1.6.jar:7.1.6] @ com.vaadin.server.vaadinservlet.service(vaadinservlet.java:238) [vaadin-server-7.1.6.jar:7.1.6] @ javax.servlet.http.httpservlet.service(httpservlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.final.jar:1.0.0.final] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:329) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:248) [jbossweb-7.0.13.final.jar:] @ org.jboss.weld.servlet.conversationpropagationfilter.dofilter(conversationpropagationfilter.java:62) [weld-core-1.1.5.as71.final.jar:2012-02-10 15:31] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:280) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:248) [jbossweb-7.0.13.final.jar:] @ org.apache.shiro.web.servlet.abstractshirofilter.executechain(abstractshirofilter.java:449) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.web.servlet.abstractshirofilter$1.call(abstractshirofilter.java:365) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.subject.support.subjectcallable.docall(subjectcallable.java:90) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.subject.support.subjectcallable.call(subjectcallable.java:83) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.subject.support.delegatingsubject.execute(delegatingsubject.java:383) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.web.servlet.abstractshirofilter.dofilterinternal(abstractshirofilter.java:362) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.shiro.web.servlet.onceperrequestfilter.dofilter(onceperrequestfilter.java:125) [shiro-all-1.2.1.jar:1.2.1] @ org.apache.catalina.core.applicationfilterchain.internaldofilter(applicationfilterchain.java:280) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.applicationfilterchain.dofilter(applicationfilterchain.java:248) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.standardwrappervalve.invoke(standardwrappervalve.java:275) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.standardcontextvalve.invoke(standardcontextvalve.java:161) [jbossweb-7.0.13.final.jar:] @ org.jboss.as.jpa.interceptor.webnontxemcloservalve.invoke(webnontxemcloservalve.java:50) [jboss-as-jpa-7.1.1.final.jar:7.1.1.final] @ org.jboss.as.web.security.securitycontextassociationvalve.invoke(securitycontextassociationvalve.java:153) [jboss-as-web-7.1.1.final.jar:7.1.1.final] @ org.apache.catalina.core.standardhostvalve.invoke(standardhostvalve.java:155) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.valves.errorreportvalve.invoke(errorreportvalve.java:102) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.core.standardenginevalve.invoke(standardenginevalve.java:109) [jbossweb-7.0.13.final.jar:] @ org.apache.catalina.connector.coyoteadapter.service(coyoteadapter.java:368) [jbossweb-7.0.13.final.jar:] @ org.apache.coyote.http11.http11processor.process(http11processor.java:877) [jbossweb-7.0.13.final.jar:] @ org.apache.coyote.http11.http11protocol$http11connectionhandler.process(http11protocol.java:671) [jbossweb-7.0.13.final.jar:] @ org.apache.tomcat.util.net.jioendpoint$worker.run(jioendpoint.java:930) [jbossweb-7.0.13.final.jar:] @ java.lang.thread.run(unknown source) [rt.jar:1.7.0_60] thank you...
edit 1 have tested query , wokrs fine too...
typedquery<products> query1 = em.createquery("select e products e e.name 'something' or e.name 'somethingelse' ",products.class); list<products> list = query1.getresultlist(); where statement not problem. problem getsingleresult, don't know how solve it... give thanks you...
can seek like
typedquery<products> q = em.createquery("select e products e e.name :something ",products.class); q.setparameter("something ", ); products products = q.getsingleresult(); mysql jpa jboss jpql
No comments:
Post a Comment