jpa criteriaQuery sample with query issue

[glassfishrobot]

jpa criteriaQuery sample with query issue

java_ee_sdk-6-web-b26-unix.sh

glassfish/samples/javaee6/jpa/criteriaQuery

The application is exact copy of the advancedMapping sample. The only difference being the queries are written using Criteria API. advancedMapping has two jpql queries, which work fine. criteriaQuery has two equilvent criteria queries, but one of them is not commented out. src/java/enterprise/criteriaQuery/ejb/StatelessSessionBean.java When I uncommented it, e.g. % diff StatelessSessionBean.java StatelessSessionBean.java.orig 85c85 < queryForOrderContainingItem("ItemName1", outputStream); —

//queryForOrderContainingItem("ItemName1", outputStream); %

I observed query failure, and error in server.log

[#|2009-11-03T16:57:30.320-0800|WARNING|glassfish|javax.enterprise.system.container.ejb.com.sun.ejb.containers|_ThreadID=27;_ThreadName=Thread-1;|A system exception occurred during an invocation on EJB StatelessSessionBean method public void enterprise.criteriaQuery.ejb.StatelessSessionBean.queryData(javax.servlet.ServletOutputStream) throws java.io.IOException javax.ejb.EJBException at com.sun.ejb.containers.BaseContainer.processSystemException(BaseContainer.java:5028) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:4926) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:4714) at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1941) at com.sun.ejb.containers.BaseContainer.postInvoke(BaseContainer.java:1892) at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:198) at com.sun.ejb.containers.EJBLocalObjectInvocationHandlerDelegate.invoke(EJBLocalObjectInvocationHandlerDelegate.java:84) at $Proxy117.queryData(Unknown Source) at enterprise.criteriaQuery.ejb.EJB31_GeneratedStatelessSessionBeanIntf__Bean.queryData(Unknown Source) at enterprise.criteriaQuery.servlet.TestServlet.processRequest(TestServlet.java:68) at enterprise.criteriaQuery.servlet.TestServlet.doGet(TestServlet.java:84) at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1523) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:279) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:188) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:641) at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:97) at com.sun.enterprise.web.PESessionLockingStandardPipeline.invoke(PESessionLockingStandardPipeline.java:85) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:185) at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:332) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:233) at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:161) at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:789) at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:697) at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:952) at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:166) at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:135) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:102) at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:88) at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:76) at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:53) at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:57) at com.sun.grizzly.ContextTask.run(ContextTask.java:69) at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:330) at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:309) at java.lang.Thread.run(Thread.java:619) Caused by: java.lang.IllegalStateException: pathnode_is_primitive_node (There is no English translation for this message.) at org.eclipse.persistence.internal.jpa.querydef.PathImpl.get(PathImpl.java:118) at enterprise.criteriaQuery.ejb.StatelessSessionBean.queryForOrderContainingItem(StatelessSessionBean.java:96) at enterprise.criteriaQuery.ejb.StatelessSessionBean.queryData(StatelessSessionBean.java:85) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.glassfish.ejb.security.application.EJBSecurityManager.runMethod(EJBSecurityManager.java:1046) at org.glassfish.ejb.security.application.EJBSecurityManager.invoke(EJBSecurityManager.java:1118) at com.sun.ejb.containers.BaseContainer.invokeBeanMethod(BaseContainer.java:5201) at com.sun.ejb.EjbInvocation.invokeBeanMethod(EjbInvocation.java:610) at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:797) at com.sun.ejb.EjbInvocation.proceed(EjbInvocation.java:562) at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.doAround(SystemInterceptorProxy.java:157) at com.sun.ejb.containers.interceptors.SystemInterceptorProxy.aroundInvoke(SystemInterceptorProxy.java:139) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.sun.ejb.containers.interceptors.AroundInvokeInterceptor.intercept(InterceptorManager.java:858) at com.sun.ejb.containers.interceptors.AroundInvokeChainImpl.invokeNext(InterceptorManager.java:797) at com.sun.ejb.containers.interceptors.InterceptorManager.intercept(InterceptorManager.java:367) at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:5173) at com.sun.ejb.containers.BaseContainer.intercept(BaseContainer.java:5161) at com.sun.ejb.containers.EJBLocalObjectInvocationHandler.invoke(EJBLocalObjectInvocationHandler.java:190) ... 31 more

| #] |

Environment

Operating System: All Platform: Sun

Affected Versions

[V3]

[glassfishrobot]

• Issue Imported From: https://github.com/javaee/glassfish/issues/10785
• Original Issue Raised By:@glassfishrobot
• Original Issue Assigned To: @yaminikb
• Original Issue Closed By:@glassfishrobot

[glassfishrobot]

@glassfishrobot Commented mm110999 said: Reassigning...

[glassfishrobot]

@glassfishrobot Commented mm110999 said: $ cvs commit -m "Uncommenting queryForOrderContainingItem as underlying EclipseLink bug i s fixed " src/java/enterprise/criteriaQuery/ejb/StatelessSessionBean.java Checking in src/java/enterprise/criteriaQuery/ejb/StatelessSessionBean.java; /cvs/glassfish-samples/ws/javaee6/jpa/criteriaQuery/src/java/enterprise/criteriaQuery/ejb/ StatelessSessionBean.java,v <-- StatelessSessionBean.java new revision: 1.3; previous revision: 1.2 done

[glassfishrobot]

@glassfishrobot Commented sherryshen said: verified the fix on java_ee_sdk-6-b29-unix.sh.

[glassfishrobot]

@glassfishrobot Commented Was assigned to mm110999

[glassfishrobot]

@glassfishrobot Commented This issue was imported from java.net JIRA GLASSFISH-10785

[glassfishrobot]

@glassfishrobot Commented Reported by sherryshen

[glassfishrobot]

@glassfishrobot Commented Marked as fixed on Friday, November 20th 2009, 8:48:42 am