Created
November 27, 2012 07:55
-
-
Save smithh032772/4153031 to your computer and use it in GitHub Desktop.
Several OrdersFacade dynamic SQL test results
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
pf_UsersController.loginUser(): administrator logged in at Tue Nov 27 01:21:54 EST 2012 | |
javax.ejb.EJBException: The bean encountered a non-application exception; nested exception is: | |
javax.persistence.PersistenceException: Collection paths cannot be restricted | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:363) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:283) | |
at jpa.session.OrdersFacade$LocalBeanProxy.filterPayroll(jpa/session/OrdersFacade.java) | |
at jsf.orders.pf_OrdersController.initPayrollDriverList(pf_OrdersController.java:2936) | |
at jsf.orders.pf_OrdersController.recreateModel(pf_OrdersController.java:16046) | |
at jsf.orders.pf_OrdersController.prepareList(pf_OrdersController.java:5961) | |
at jsf.orders.pf_OrdersController.prepareList(pf_OrdersController.java:5913) | |
at jsf.orders.pf_OrdersController.browseOrdersPayroll(pf_OrdersController.java:1249) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:322) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:117) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:108) | |
at jsf.orders.pf_OrdersController_$$_javassist_13.browseOrdersPayroll(pf_OrdersController_$$_javassist_13.java) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at javax.el.BeanELResolver.invokeMethod(BeanELResolver.java:737) | |
at javax.el.BeanELResolver.invoke(BeanELResolver.java:467) | |
at javax.el.CompositeELResolver.invoke(CompositeELResolver.java:246) | |
at de.odysseus.el.tree.impl.ast.AstMethod.eval(AstMethod.java:91) | |
at de.odysseus.el.tree.impl.ast.AstMethod.invoke(AstMethod.java:104) | |
at de.odysseus.el.tree.impl.ast.AstEval.invoke(AstEval.java:71) | |
at de.odysseus.el.TreeMethodExpression.invoke(TreeMethodExpression.java:132) | |
at org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96) | |
at javax.faces.event.MethodExpressionActionListener.processAction(MethodExpressionActionListener.java:83) | |
at javax.faces.event.ActionEvent.processListener(ActionEvent.java:51) | |
at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:418) | |
at javax.faces.component.UICommand.broadcast(UICommand.java:103) | |
at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028) | |
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286) | |
at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375) | |
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752) | |
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117) | |
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:148) | |
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at pf.LoginFilter.doFilter(LoginFilter.java:194) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) | |
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) | |
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) | |
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) | |
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) | |
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) | |
at java.lang.Thread.run(Thread.java:722) | |
Caused by: javax.persistence.PersistenceException: Collection paths cannot be restricted | |
at org.batoo.jpa.core.impl.criteria.expression.CollectionExpression.getSqlRestrictionFragments(CollectionExpression.java:120) | |
at org.batoo.jpa.core.impl.criteria.expression.ComparisonExpression.getSqlRestrictionFragments(ComparisonExpression.java:177) | |
at org.batoo.jpa.core.impl.criteria.expression.BooleanExpression.generateSqlRestriction(BooleanExpression.java:85) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:168) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:164) | |
at com.google.common.collect.Lists$TransformingRandomAccessList.get(Lists.java:451) | |
at java.util.AbstractList$Itr.next(AbstractList.java:358) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:121) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:181) | |
at com.google.common.base.Joiner.join(Joiner.java:237) | |
at com.google.common.base.Joiner.join(Joiner.java:226) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl.generateSqlRestriction(PredicateImpl.java:164) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:168) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:164) | |
at com.google.common.collect.Lists$TransformingRandomAccessList.get(Lists.java:451) | |
at java.util.AbstractList$Itr.next(AbstractList.java:358) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:124) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:181) | |
at com.google.common.base.Joiner.join(Joiner.java:237) | |
at com.google.common.base.Joiner.join(Joiner.java:226) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl.generateSqlRestriction(PredicateImpl.java:164) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:168) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:164) | |
at com.google.common.collect.Lists$TransformingRandomAccessList.get(Lists.java:451) | |
at java.util.AbstractList$Itr.next(AbstractList.java:358) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:121) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:181) | |
at com.google.common.base.Joiner.join(Joiner.java:237) | |
at com.google.common.base.Joiner.join(Joiner.java:226) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl.generateSqlRestriction(PredicateImpl.java:164) | |
at org.batoo.jpa.core.impl.criteria.AbstractCriteriaQueryImpl.generateSqlRestriction(AbstractCriteriaQueryImpl.java:311) | |
at org.batoo.jpa.core.impl.criteria.AbstractCriteriaQueryImpl.generateSql(AbstractCriteriaQueryImpl.java:272) | |
at org.batoo.jpa.core.impl.criteria.CriteriaQueryImpl.generateSql(CriteriaQueryImpl.java:132) | |
at org.batoo.jpa.core.impl.criteria.BaseQueryImpl.getSql(BaseQueryImpl.java:234) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.<init>(QueryImpl.java:124) | |
at org.batoo.jpa.core.impl.criteria.jpql.JpqlQuery.createTypedQuery(JpqlQuery.java:769) | |
at org.batoo.jpa.core.impl.manager.EntityManagerImpl.createQuery(EntityManagerImpl.java:398) | |
at org.apache.openejb.persistence.JtaEntityManager.createQuery(JtaEntityManager.java:263) | |
at jpa.session.OrdersFacade.filterPayroll(OrdersFacade.java:611) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:128) | |
at org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:43) | |
at org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:64) | |
at org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:70) | |
at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176) | |
at org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95) | |
at sun.reflect.GeneratedMethodAccessor119.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138) | |
at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:237) | |
at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:189) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:253) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:248) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:92) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279) | |
... 65 more | |
javax.ejb.EJBException: The bean encountered a non-application exception; nested exception is: | |
javax.persistence.PersistenceException: Collection paths cannot be restricted | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:363) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:283) | |
at jpa.session.OrdersFacade$LocalBeanProxy.getDriversForPayrollAndDriverMoney(jpa/session/OrdersFacade.java) | |
at jsf.orders.pf_OrdersController.getSelectOneDriverForPayrollAndDriverMoney(pf_OrdersController.java:3044) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:322) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:117) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:108) | |
at jsf.orders.pf_OrdersController_$$_javassist_13.getSelectOneDriverForPayrollAndDriverMoney(pf_OrdersController_$$_javassist_13.java) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at javax.el.BeanELResolver.getValue(BeanELResolver.java:302) | |
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) | |
at de.odysseus.el.tree.impl.ast.AstProperty.eval(AstProperty.java:77) | |
at de.odysseus.el.tree.impl.ast.AstEval.eval(AstEval.java:51) | |
at de.odysseus.el.tree.impl.ast.AstNode.getValue(AstNode.java:30) | |
at de.odysseus.el.TreeValueExpression.getValue(TreeValueExpression.java:122) | |
at org.apache.webbeans.el.WrappedValueExpression.getValue(WrappedValueExpression.java:68) | |
at org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96) | |
at javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:249) | |
at javax.faces.component.UISelectItems.getValue(UISelectItems.java:85) | |
at org.apache.myfaces.shared.util.SelectItemsIterator.hasNext(SelectItemsIterator.java:149) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.internalGetSelectItemList(RendererUtils.java:798) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.getSelectItemList(RendererUtils.java:764) | |
at org.apache.myfaces.shared.renderkit.html.HtmlSelectableRendererBase.internalRenderSelect(HtmlSelectableRendererBase.java:74) | |
at org.apache.myfaces.shared.renderkit.html.HtmlMenuRendererBase.renderMenu(HtmlMenuRendererBase.java:91) | |
at org.apache.myfaces.shared.renderkit.html.HtmlMenuRendererBase.encodeEnd(HtmlMenuRendererBase.java:76) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:543) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.renderChildren(HtmlGridRendererBase.java:370) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.encodeEnd(HtmlGridRendererBase.java:194) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:543) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.renderChildren(HtmlGridRendererBase.java:370) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.encodeEnd(HtmlGridRendererBase.java:194) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:543) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.renderChildren(RendererUtils.java:693) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGroupRendererBase.encodeEnd(HtmlGroupRendererBase.java:115) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:207) | |
at org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:124) | |
at org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:55) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:60) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.extensions.component.layout.LayoutPaneRenderer.encodeBegin(LayoutPaneRenderer.java:141) | |
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:585) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:55) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:46) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.extensions.component.layout.LayoutPaneRenderer.encodeBegin(LayoutPaneRenderer.java:141) | |
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:585) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:515) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981) | |
at org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:285) | |
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) | |
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) | |
at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241) | |
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:199) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:148) | |
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at pf.LoginFilter.doFilter(LoginFilter.java:194) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) | |
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) | |
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) | |
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) | |
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) | |
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) | |
at java.lang.Thread.run(Thread.java:722) | |
Caused by: javax.persistence.PersistenceException: Collection paths cannot be restricted | |
at org.batoo.jpa.core.impl.criteria.expression.CollectionExpression.getSqlRestrictionFragments(CollectionExpression.java:120) | |
at org.batoo.jpa.core.impl.criteria.expression.ComparisonExpression.getSqlRestrictionFragments(ComparisonExpression.java:177) | |
at org.batoo.jpa.core.impl.criteria.expression.BooleanExpression.generateSqlRestriction(BooleanExpression.java:85) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:168) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:164) | |
at com.google.common.collect.Lists$TransformingRandomAccessList.get(Lists.java:451) | |
at java.util.AbstractList$Itr.next(AbstractList.java:358) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:121) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:181) | |
at com.google.common.base.Joiner.join(Joiner.java:237) | |
at com.google.common.base.Joiner.join(Joiner.java:226) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl.generateSqlRestriction(PredicateImpl.java:164) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:168) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:164) | |
at com.google.common.collect.Lists$TransformingRandomAccessList.get(Lists.java:451) | |
at java.util.AbstractList$Itr.next(AbstractList.java:358) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:124) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:181) | |
at com.google.common.base.Joiner.join(Joiner.java:237) | |
at com.google.common.base.Joiner.join(Joiner.java:226) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl.generateSqlRestriction(PredicateImpl.java:164) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:168) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl$2.apply(PredicateImpl.java:164) | |
at com.google.common.collect.Lists$TransformingRandomAccessList.get(Lists.java:451) | |
at java.util.AbstractList$Itr.next(AbstractList.java:358) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:121) | |
at com.google.common.base.Joiner.appendTo(Joiner.java:181) | |
at com.google.common.base.Joiner.join(Joiner.java:237) | |
at com.google.common.base.Joiner.join(Joiner.java:226) | |
at org.batoo.jpa.core.impl.criteria.expression.PredicateImpl.generateSqlRestriction(PredicateImpl.java:164) | |
at org.batoo.jpa.core.impl.criteria.AbstractCriteriaQueryImpl.generateSqlRestriction(AbstractCriteriaQueryImpl.java:311) | |
at org.batoo.jpa.core.impl.criteria.AbstractCriteriaQueryImpl.generateSql(AbstractCriteriaQueryImpl.java:272) | |
at org.batoo.jpa.core.impl.criteria.CriteriaQueryImpl.generateSql(CriteriaQueryImpl.java:132) | |
at org.batoo.jpa.core.impl.criteria.BaseQueryImpl.getSql(BaseQueryImpl.java:234) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.<init>(QueryImpl.java:124) | |
at org.batoo.jpa.core.impl.criteria.jpql.JpqlQuery.createTypedQuery(JpqlQuery.java:769) | |
at org.batoo.jpa.core.impl.manager.EntityManagerImpl.createQuery(EntityManagerImpl.java:398) | |
at org.apache.openejb.persistence.JtaEntityManager.createQuery(JtaEntityManager.java:263) | |
at jpa.session.OrdersFacade.getDriversForPayrollAndDriverMoney(OrdersFacade.java:638) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:128) | |
at org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:43) | |
at org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:64) | |
at org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:70) | |
at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176) | |
at org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95) | |
at sun.reflect.GeneratedMethodAccessor119.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138) | |
at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:237) | |
at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:189) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:253) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:248) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:92) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279) | |
... 101 more | |
[http-bio-8080-exec-19] ERROR org.batoo.jpa.core.impl.criteria.QueryImpl - Query failed | |
----------------------------------------------------------------------------------------------- | |
| select distinct a.orders as o | | |
| from AuditTrail as a | | |
| inner join a.orders as o | | |
| left join fetch o.orders | | |
| where | | |
| a.auditTrailDt BETWEEN '2012-11-27 00:00:00' AND '2012-11-27 23:59:59' AND not (exists( | | |
| select ot | | |
| from OrderTemplate as ot | | |
| where | | |
| ot.templateId = o.templateId.templateId)) | | |
| order by | | |
| o.reportDateTime asc, o.tripDateTime asc, o.customerId.customerName asc | | |
----------------------------------------------------------------------------------------------- | |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |
| SELECT DISTINCT | | |
| E0_P.TRIP_DATE_TIME AS E0_P_F1, E0_P.CANCELLED_DATE AS E0_P_F2, E0_P.BANK_FOR_DEPOSIT_ID AS E0_P_F3, E0_P.CUSTOMER_ID AS E0_P_F4, E0_P.TEMPLATE_ID AS E0_P_F5, E0_P.DEPOSIT AS E0_P_F6, E0_P.CONFIRMED_DATE AS E0_P_F7, E0_P.DISCOUNT_RATE AS E0_P_F8, E0_P.DETAILS_ID AS E0_P_F9, E0_P.ROUTES_ID AS E0_P_F10, E0_P.CREATED_BY AS E0_P_F11, E0_P.DEPOSIT_PAID_DATE AS E0_P_F12, E0_P.TOTAL_COST AS E0_P_F13, E0_P.NOTES_ID AS E0_P_F14, E0_P.BANK_FOR_BALANCE_ID AS E0_P_F15, E0_P.METHOD_OF_PAYMENT_FOR_DEPOSIT_ID AS E0_P_F16, E0_P.DISCOUNT AS E0_P_F17, E0_P.PASSENGERS AS E0_P_F18, E0_P.INVOICE_SENT AS E0_P_F19, E0_P.CREATED_DT AS E0_P_F20, E0_P.BALANCE AS E0_P_F21, E0_P.CONTRACT_SENT_DATE AS E0_P_F22, E0_P.INTRASTATE AS E0_P_F23, E0_P.PAID_IN_FULL_DATE AS E0_P_F24, E0_P.DEPOSIT_PAID AS E0_P_F25, E0_P.INVOICE_SENT_DATE AS E0_P_F26, E0_P.CANCELLED AS E0_P_F27, E0_P.CHANGED_DT AS E0_P_F28, E0_P.QUOTE_SENT AS E0_P_F29, E0_P.METHOD_OF_PAYMENT_FOR_BALANCE_ID AS E0_P_F30, E0_P.ORDER_ID AS E0_P_F31, E0_P.CONTRACT_SENT AS E0_P_F32, E0_P.CONFIRMED AS E0_P_F33, E0_P.REPORT_DATE_TIME AS E0_P_F0, E0_P.PAID_IN_FULL AS E0_P_F34, E0_P.QUOTE_SENT_DATE AS E0_P_F35, E0_P.RETURN_DATE_TIME AS E0_P_F36 | | |
| FROM AUDIT_TRAIL E2_P | | |
| INNER JOIN ORDER_AUDIT_TRAIL E0_P_J ON E2_P.AUDIT_TRAIL_ID = E0_P_J.AUDIT_TRAIL_ID | | |
| INNER JOIN ORDERS E0_P ON E0_P_J.ORDER_ID = E0_P.ORDER_ID | | |
| LEFT JOIN CUSTOMER E1_P ON E0_P.CUSTOMER_ID = E1_P.CUSTOMER_ID | | |
| WHERE | | |
| (E2_P.AUDIT_TRAIL_DT BETWEEN '2012-11-27 00:00:00' AND '2012-11-27 23:59:59' AND NOT (EXISTS( | | |
| SELECT | | |
| E3_P.DESCRIPTION_TX AS E3_P_F0, E3_P.TEMPLATE_NAME AS E3_P_F1, E3_P.TEMPLATE_ID AS E3_P_F2 | | |
| FROM ORDER_TEMPLATE E3_P | | |
| WHERE | | |
| (E3_P.TEMPLATE_ID = E0_P.TEMPLATE_ID)))) | | |
| ORDER BY | | |
| E0_P.REPORT_DATE_TIME asc, E0_P.TRIP_DATE_TIME asc, E1_P.CUSTOMER_NAME asc | | |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |
java.sql.SQLSyntaxErrorException: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) | |
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67) | |
at org.apache.tomcat.jdbc.pool.interceptor.StatementCache.invoke(StatementCache.java:172) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) | |
at $Proxy105.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.tomee.jdbc.TomEEDataSourceCreator$ContantHashCodeHandler.invoke(TomEEDataSourceCreator.java:319) | |
at $Proxy140.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invokeUnderTransaction(ManagedConnection.java:151) | |
at org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invoke(ManagedConnection.java:117) | |
at $Proxy140.prepareStatement(Unknown Source) | |
at org.batoo.jpa.jdbc.ConnectionProxy.prepareStatement(ConnectionProxy.java:375) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.buildResultSetImpl(QueryImpl.java:350) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.buildResultSet(QueryImpl.java:293) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.getResultListImpl(QueryImpl.java:819) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.getResultList(QueryImpl.java:775) | |
at jpa.session.OrdersFacade.getOrdersForAuditTrail(OrdersFacade.java:722) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:128) | |
at org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:43) | |
at org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:64) | |
at org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:70) | |
at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176) | |
at org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95) | |
at sun.reflect.GeneratedMethodAccessor119.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138) | |
at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:237) | |
at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:189) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:253) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:248) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:92) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279) | |
at jpa.session.OrdersFacade$LocalBeanProxy.getOrdersForAuditTrail(jpa/session/OrdersFacade.java) | |
at jsf.orders.pf_OrdersController.getSelectOneOrderForAuditTrail(pf_OrdersController.java:3063) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:322) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:117) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:108) | |
at jsf.orders.pf_OrdersController_$$_javassist_13.getSelectOneOrderForAuditTrail(pf_OrdersController_$$_javassist_13.java) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at javax.el.BeanELResolver.getValue(BeanELResolver.java:302) | |
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) | |
at de.odysseus.el.tree.impl.ast.AstProperty.eval(AstProperty.java:77) | |
at de.odysseus.el.tree.impl.ast.AstEval.eval(AstEval.java:51) | |
at de.odysseus.el.tree.impl.ast.AstNode.getValue(AstNode.java:30) | |
at de.odysseus.el.TreeValueExpression.getValue(TreeValueExpression.java:122) | |
at org.apache.webbeans.el.WrappedValueExpression.getValue(WrappedValueExpression.java:68) | |
at org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96) | |
at javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:249) | |
at javax.faces.component.UISelectItems.getValue(UISelectItems.java:85) | |
at org.apache.myfaces.shared.util.SelectItemsIterator.hasNext(SelectItemsIterator.java:149) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.internalGetSelectItemList(RendererUtils.java:798) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.getSelectItemList(RendererUtils.java:764) | |
at org.apache.myfaces.shared.renderkit.html.HtmlSelectableRendererBase.internalRenderSelect(HtmlSelectableRendererBase.java:74) | |
at org.apache.myfaces.shared.renderkit.html.HtmlMenuRendererBase.renderMenu(HtmlMenuRendererBase.java:91) | |
at org.apache.myfaces.shared.renderkit.html.HtmlMenuRendererBase.encodeEnd(HtmlMenuRendererBase.java:76) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:543) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.renderChildren(HtmlGridRendererBase.java:370) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.encodeEnd(HtmlGridRendererBase.java:194) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:207) | |
at org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:124) | |
at org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:55) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:60) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.extensions.component.layout.LayoutPaneRenderer.encodeBegin(LayoutPaneRenderer.java:141) | |
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:585) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:55) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:46) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.extensions.component.layout.LayoutPaneRenderer.encodeBegin(LayoutPaneRenderer.java:141) | |
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:585) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:515) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981) | |
at org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:285) | |
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) | |
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) | |
at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241) | |
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:199) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:148) | |
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at pf.LoginFilter.doFilter(LoginFilter.java:194) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) | |
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) | |
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) | |
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) | |
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) | |
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) | |
at java.lang.Thread.run(Thread.java:722) | |
Caused by: java.sql.SQLException: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) | |
... 164 more | |
Caused by: ERROR 42879: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) | |
at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown Source) | |
at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown Source) | |
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) | |
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) | |
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) | |
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) | |
... 158 more | |
javax.ejb.EJBException: The bean encountered a non-application exception; nested exception is: | |
javax.persistence.PersistenceException: Query failed | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:363) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:283) | |
at jpa.session.OrdersFacade$LocalBeanProxy.getOrdersForAuditTrail(jpa/session/OrdersFacade.java) | |
at jsf.orders.pf_OrdersController.getSelectOneOrderForAuditTrail(pf_OrdersController.java:3063) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:322) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:117) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:108) | |
at jsf.orders.pf_OrdersController_$$_javassist_13.getSelectOneOrderForAuditTrail(pf_OrdersController_$$_javassist_13.java) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at javax.el.BeanELResolver.getValue(BeanELResolver.java:302) | |
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) | |
at de.odysseus.el.tree.impl.ast.AstProperty.eval(AstProperty.java:77) | |
at de.odysseus.el.tree.impl.ast.AstEval.eval(AstEval.java:51) | |
at de.odysseus.el.tree.impl.ast.AstNode.getValue(AstNode.java:30) | |
at de.odysseus.el.TreeValueExpression.getValue(TreeValueExpression.java:122) | |
at org.apache.webbeans.el.WrappedValueExpression.getValue(WrappedValueExpression.java:68) | |
at org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96) | |
at javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:249) | |
at javax.faces.component.UISelectItems.getValue(UISelectItems.java:85) | |
at org.apache.myfaces.shared.util.SelectItemsIterator.hasNext(SelectItemsIterator.java:149) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.internalGetSelectItemList(RendererUtils.java:798) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.getSelectItemList(RendererUtils.java:764) | |
at org.apache.myfaces.shared.renderkit.html.HtmlSelectableRendererBase.internalRenderSelect(HtmlSelectableRendererBase.java:74) | |
at org.apache.myfaces.shared.renderkit.html.HtmlMenuRendererBase.renderMenu(HtmlMenuRendererBase.java:91) | |
at org.apache.myfaces.shared.renderkit.html.HtmlMenuRendererBase.encodeEnd(HtmlMenuRendererBase.java:76) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:543) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.renderChildren(HtmlGridRendererBase.java:370) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.encodeEnd(HtmlGridRendererBase.java:194) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:207) | |
at org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:124) | |
at org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:55) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:60) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.extensions.component.layout.LayoutPaneRenderer.encodeBegin(LayoutPaneRenderer.java:141) | |
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:585) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:55) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.component.outputpanel.OutputPanelRenderer.encodeEnd(OutputPanelRenderer.java:46) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.extensions.component.layout.LayoutPaneRenderer.encodeBegin(LayoutPaneRenderer.java:141) | |
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:585) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:515) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981) | |
at org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:285) | |
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) | |
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) | |
at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241) | |
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:199) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:148) | |
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at pf.LoginFilter.doFilter(LoginFilter.java:194) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) | |
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) | |
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) | |
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) | |
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) | |
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) | |
at java.lang.Thread.run(Thread.java:722) | |
Caused by: javax.persistence.PersistenceException: Query failed | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.buildResultSet(QueryImpl.java:307) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.getResultListImpl(QueryImpl.java:819) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.getResultList(QueryImpl.java:775) | |
at jpa.session.OrdersFacade.getOrdersForAuditTrail(OrdersFacade.java:722) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:128) | |
at org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:43) | |
at org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:64) | |
at org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:70) | |
at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176) | |
at org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95) | |
at sun.reflect.GeneratedMethodAccessor119.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138) | |
at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:237) | |
at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:189) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:253) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:248) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:92) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279) | |
... 93 more | |
Caused by: java.sql.SQLSyntaxErrorException: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) | |
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67) | |
at org.apache.tomcat.jdbc.pool.interceptor.StatementCache.invoke(StatementCache.java:172) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) | |
at $Proxy105.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.tomee.jdbc.TomEEDataSourceCreator$ContantHashCodeHandler.invoke(TomEEDataSourceCreator.java:319) | |
at $Proxy140.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invokeUnderTransaction(ManagedConnection.java:151) | |
at org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invoke(ManagedConnection.java:117) | |
at $Proxy140.prepareStatement(Unknown Source) | |
at org.batoo.jpa.jdbc.ConnectionProxy.prepareStatement(ConnectionProxy.java:375) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.buildResultSetImpl(QueryImpl.java:350) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.buildResultSet(QueryImpl.java:293) | |
... 125 more | |
Caused by: java.sql.SQLException: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) | |
... 164 more | |
Caused by: ERROR 42879: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) | |
at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown Source) | |
at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown Source) | |
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) | |
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) | |
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) | |
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) | |
... 158 more | |
java.lang.NullPointerException | |
at java.util.ArrayList.<init>(ArrayList.java:151) | |
at jsf.orders.pf_OrdersController.initAuditTrailList(pf_OrdersController.java:1801) | |
at jsf.orders.pf_OrdersController.recreateModel(pf_OrdersController.java:16042) | |
at jsf.orders.pf_OrdersController.prepareList(pf_OrdersController.java:5961) | |
at jsf.orders.pf_OrdersController.prepareList(pf_OrdersController.java:5913) | |
at jsf.orders.pf_OrdersController.filterTripDateFromSelected(pf_OrdersController.java:4852) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:322) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:117) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:108) | |
at jsf.orders.pf_OrdersController_$$_javassist_13.filterTripDateFromSelected(pf_OrdersController_$$_javassist_13.java) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at de.odysseus.el.tree.impl.ast.AstProperty.invoke(AstProperty.java:205) | |
at de.odysseus.el.tree.impl.ast.AstEval.invoke(AstEval.java:71) | |
at de.odysseus.el.TreeMethodExpression.invoke(TreeMethodExpression.java:132) | |
at org.primefaces.component.behavior.ajax.AjaxBehaviorListenerImpl.processAjaxBehavior(AjaxBehaviorListenerImpl.java:52) | |
at org.primefaces.event.DateSelectEvent.processListener(DateSelectEvent.java:42) | |
at javax.faces.component.behavior.BehaviorBase.broadcast(BehaviorBase.java:74) | |
at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:405) | |
at javax.faces.component.UIInput.broadcast(UIInput.java:359) | |
at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1028) | |
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:286) | |
at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1375) | |
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:752) | |
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:38) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:170) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:117) | |
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:148) | |
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at pf.LoginFilter.doFilter(LoginFilter.java:194) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) | |
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) | |
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) | |
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) | |
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) | |
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) | |
at java.lang.Thread.run(Thread.java:722) | |
[http-bio-8080-exec-19] ERROR org.batoo.jpa.core.impl.criteria.QueryImpl - Query failed | |
----------------------------------------------------------------------------------------------- | |
| select distinct a.orders as o | | |
| from AuditTrail as a | | |
| inner join a.orders as o | | |
| left join fetch o.orders | | |
| where | | |
| a.auditTrailDt BETWEEN '2012-11-19 00:00:00' AND '2012-11-19 23:59:59' AND not (exists( | | |
| select ot | | |
| from OrderTemplate as ot | | |
| where | | |
| ot.templateId = o.templateId.templateId)) | | |
| order by | | |
| o.reportDateTime asc, o.tripDateTime asc, o.customerId.customerName asc | | |
----------------------------------------------------------------------------------------------- | |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |
| SELECT DISTINCT | | |
| E0_P.TRIP_DATE_TIME AS E0_P_F1, E0_P.CANCELLED_DATE AS E0_P_F2, E0_P.BANK_FOR_DEPOSIT_ID AS E0_P_F3, E0_P.CUSTOMER_ID AS E0_P_F4, E0_P.TEMPLATE_ID AS E0_P_F5, E0_P.DEPOSIT AS E0_P_F6, E0_P.CONFIRMED_DATE AS E0_P_F7, E0_P.DISCOUNT_RATE AS E0_P_F8, E0_P.DETAILS_ID AS E0_P_F9, E0_P.ROUTES_ID AS E0_P_F10, E0_P.CREATED_BY AS E0_P_F11, E0_P.DEPOSIT_PAID_DATE AS E0_P_F12, E0_P.TOTAL_COST AS E0_P_F13, E0_P.NOTES_ID AS E0_P_F14, E0_P.BANK_FOR_BALANCE_ID AS E0_P_F15, E0_P.METHOD_OF_PAYMENT_FOR_DEPOSIT_ID AS E0_P_F16, E0_P.DISCOUNT AS E0_P_F17, E0_P.PASSENGERS AS E0_P_F18, E0_P.INVOICE_SENT AS E0_P_F19, E0_P.CREATED_DT AS E0_P_F20, E0_P.BALANCE AS E0_P_F21, E0_P.CONTRACT_SENT_DATE AS E0_P_F22, E0_P.INTRASTATE AS E0_P_F23, E0_P.PAID_IN_FULL_DATE AS E0_P_F24, E0_P.DEPOSIT_PAID AS E0_P_F25, E0_P.INVOICE_SENT_DATE AS E0_P_F26, E0_P.CANCELLED AS E0_P_F27, E0_P.CHANGED_DT AS E0_P_F28, E0_P.QUOTE_SENT AS E0_P_F29, E0_P.METHOD_OF_PAYMENT_FOR_BALANCE_ID AS E0_P_F30, E0_P.ORDER_ID AS E0_P_F31, E0_P.CONTRACT_SENT AS E0_P_F32, E0_P.CONFIRMED AS E0_P_F33, E0_P.REPORT_DATE_TIME AS E0_P_F0, E0_P.PAID_IN_FULL AS E0_P_F34, E0_P.QUOTE_SENT_DATE AS E0_P_F35, E0_P.RETURN_DATE_TIME AS E0_P_F36 | | |
| FROM AUDIT_TRAIL E2_P | | |
| INNER JOIN ORDER_AUDIT_TRAIL E0_P_J ON E2_P.AUDIT_TRAIL_ID = E0_P_J.AUDIT_TRAIL_ID | | |
| INNER JOIN ORDERS E0_P ON E0_P_J.ORDER_ID = E0_P.ORDER_ID | | |
| LEFT JOIN CUSTOMER E1_P ON E0_P.CUSTOMER_ID = E1_P.CUSTOMER_ID | | |
| WHERE | | |
| (E2_P.AUDIT_TRAIL_DT BETWEEN '2012-11-19 00:00:00' AND '2012-11-19 23:59:59' AND NOT (EXISTS( | | |
| SELECT | | |
| E3_P.DESCRIPTION_TX AS E3_P_F0, E3_P.TEMPLATE_NAME AS E3_P_F1, E3_P.TEMPLATE_ID AS E3_P_F2 | | |
| FROM ORDER_TEMPLATE E3_P | | |
| WHERE | | |
| (E3_P.TEMPLATE_ID = E0_P.TEMPLATE_ID)))) | | |
| ORDER BY | | |
| E0_P.REPORT_DATE_TIME asc, E0_P.TRIP_DATE_TIME asc, E1_P.CUSTOMER_NAME asc | | |
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | |
java.sql.SQLSyntaxErrorException: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) | |
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67) | |
at org.apache.tomcat.jdbc.pool.interceptor.StatementCache.invoke(StatementCache.java:172) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) | |
at $Proxy105.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.tomee.jdbc.TomEEDataSourceCreator$ContantHashCodeHandler.invoke(TomEEDataSourceCreator.java:319) | |
at $Proxy140.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invokeUnderTransaction(ManagedConnection.java:151) | |
at org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invoke(ManagedConnection.java:117) | |
at $Proxy140.prepareStatement(Unknown Source) | |
at org.batoo.jpa.jdbc.ConnectionProxy.prepareStatement(ConnectionProxy.java:375) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.buildResultSetImpl(QueryImpl.java:350) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.buildResultSet(QueryImpl.java:293) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.getResultListImpl(QueryImpl.java:819) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.getResultList(QueryImpl.java:775) | |
at jpa.session.OrdersFacade.getOrdersForAuditTrail(OrdersFacade.java:722) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:128) | |
at org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:43) | |
at org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:64) | |
at org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:70) | |
at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176) | |
at org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95) | |
at sun.reflect.GeneratedMethodAccessor119.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138) | |
at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:237) | |
at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:189) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:253) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:248) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:92) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279) | |
at jpa.session.OrdersFacade$LocalBeanProxy.getOrdersForAuditTrail(jpa/session/OrdersFacade.java) | |
at jsf.orders.pf_OrdersController.getSelectOneOrderForAuditTrail(pf_OrdersController.java:3063) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:322) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:117) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:108) | |
at jsf.orders.pf_OrdersController_$$_javassist_13.getSelectOneOrderForAuditTrail(pf_OrdersController_$$_javassist_13.java) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at javax.el.BeanELResolver.getValue(BeanELResolver.java:302) | |
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) | |
at de.odysseus.el.tree.impl.ast.AstProperty.eval(AstProperty.java:77) | |
at de.odysseus.el.tree.impl.ast.AstEval.eval(AstEval.java:51) | |
at de.odysseus.el.tree.impl.ast.AstNode.getValue(AstNode.java:30) | |
at de.odysseus.el.TreeValueExpression.getValue(TreeValueExpression.java:122) | |
at org.apache.webbeans.el.WrappedValueExpression.getValue(WrappedValueExpression.java:68) | |
at org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96) | |
at javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:249) | |
at javax.faces.component.UISelectItems.getValue(UISelectItems.java:85) | |
at org.apache.myfaces.shared.util.SelectItemsIterator.hasNext(SelectItemsIterator.java:149) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.internalGetSelectItemList(RendererUtils.java:798) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.getSelectItemList(RendererUtils.java:764) | |
at org.apache.myfaces.shared.renderkit.html.HtmlSelectableRendererBase.internalRenderSelect(HtmlSelectableRendererBase.java:74) | |
at org.apache.myfaces.shared.renderkit.html.HtmlMenuRendererBase.renderMenu(HtmlMenuRendererBase.java:91) | |
at org.apache.myfaces.shared.renderkit.html.HtmlMenuRendererBase.encodeEnd(HtmlMenuRendererBase.java:76) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:543) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.renderChildren(HtmlGridRendererBase.java:370) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.encodeEnd(HtmlGridRendererBase.java:194) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:207) | |
at org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:124) | |
at org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:55) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:543) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at org.apache.myfaces.context.servlet.PartialViewContextImpl$PhaseAwareVisitCallback.processRenderComponent(PartialViewContextImpl.java:782) | |
at org.apache.myfaces.context.servlet.PartialViewContextImpl$PhaseAwareVisitCallback.visit(PartialViewContextImpl.java:743) | |
at org.apache.myfaces.component.visit.PartialVisitContext.invokeVisitCallback(PartialVisitContext.java:214) | |
at javax.faces.component.UIForm.visitTree(UIForm.java:323) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at org.apache.myfaces.context.servlet.PartialViewContextImpl.processPartialRendering(PartialViewContextImpl.java:518) | |
at org.apache.myfaces.context.servlet.PartialViewContextImpl.processPartial(PartialViewContextImpl.java:405) | |
at javax.faces.context.PartialViewContextWrapper.processPartial(PartialViewContextWrapper.java:88) | |
at javax.faces.context.PartialViewContextWrapper.processPartial(PartialViewContextWrapper.java:88) | |
at javax.faces.component.UIViewRoot.encodeChildren(UIViewRoot.java:408) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:530) | |
at org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981) | |
at org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:285) | |
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) | |
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) | |
at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241) | |
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:199) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:148) | |
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at pf.LoginFilter.doFilter(LoginFilter.java:194) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) | |
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) | |
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) | |
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) | |
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) | |
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) | |
at java.lang.Thread.run(Thread.java:722) | |
Caused by: java.sql.SQLException: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) | |
... 170 more | |
Caused by: ERROR 42879: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) | |
at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown Source) | |
at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown Source) | |
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) | |
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) | |
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) | |
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) | |
... 164 more | |
javax.ejb.EJBException: The bean encountered a non-application exception; nested exception is: | |
javax.persistence.PersistenceException: Query failed | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.convertException(BaseEjbProxyHandler.java:363) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:283) | |
at jpa.session.OrdersFacade$LocalBeanProxy.getOrdersForAuditTrail(jpa/session/OrdersFacade.java) | |
at jsf.orders.pf_OrdersController.getSelectOneOrderForAuditTrail(pf_OrdersController.java:3063) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.webbeans.intercept.InterceptorHandler.invoke(InterceptorHandler.java:322) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:117) | |
at org.apache.webbeans.intercept.NormalScopedBeanInterceptorHandler.invoke(NormalScopedBeanInterceptorHandler.java:108) | |
at jsf.orders.pf_OrdersController_$$_javassist_13.getSelectOneOrderForAuditTrail(pf_OrdersController_$$_javassist_13.java) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at javax.el.BeanELResolver.getValue(BeanELResolver.java:302) | |
at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:175) | |
at de.odysseus.el.tree.impl.ast.AstProperty.eval(AstProperty.java:77) | |
at de.odysseus.el.tree.impl.ast.AstEval.eval(AstEval.java:51) | |
at de.odysseus.el.tree.impl.ast.AstNode.getValue(AstNode.java:30) | |
at de.odysseus.el.TreeValueExpression.getValue(TreeValueExpression.java:122) | |
at org.apache.webbeans.el.WrappedValueExpression.getValue(WrappedValueExpression.java:68) | |
at org.apache.myfaces.view.facelets.el.ContextAwareTagValueExpression.getValue(ContextAwareTagValueExpression.java:96) | |
at javax.faces.component._DeltaStateHelper.eval(_DeltaStateHelper.java:249) | |
at javax.faces.component.UISelectItems.getValue(UISelectItems.java:85) | |
at org.apache.myfaces.shared.util.SelectItemsIterator.hasNext(SelectItemsIterator.java:149) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.internalGetSelectItemList(RendererUtils.java:798) | |
at org.apache.myfaces.shared.renderkit.RendererUtils.getSelectItemList(RendererUtils.java:764) | |
at org.apache.myfaces.shared.renderkit.html.HtmlSelectableRendererBase.internalRenderSelect(HtmlSelectableRendererBase.java:74) | |
at org.apache.myfaces.shared.renderkit.html.HtmlMenuRendererBase.renderMenu(HtmlMenuRendererBase.java:91) | |
at org.apache.myfaces.shared.renderkit.html.HtmlMenuRendererBase.encodeEnd(HtmlMenuRendererBase.java:76) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:543) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.renderChildren(HtmlGridRendererBase.java:370) | |
at org.apache.myfaces.shared.renderkit.html.HtmlGridRendererBase.encodeEnd(HtmlGridRendererBase.java:194) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at org.primefaces.renderkit.CoreRenderer.renderChild(CoreRenderer.java:62) | |
at org.primefaces.renderkit.CoreRenderer.renderChildren(CoreRenderer.java:46) | |
at org.primefaces.component.panel.PanelRenderer.encodeContent(PanelRenderer.java:207) | |
at org.primefaces.component.panel.PanelRenderer.encodeMarkup(PanelRenderer.java:124) | |
at org.primefaces.component.panel.PanelRenderer.encodeEnd(PanelRenderer.java:55) | |
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:663) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:543) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:539) | |
at org.apache.myfaces.context.servlet.PartialViewContextImpl$PhaseAwareVisitCallback.processRenderComponent(PartialViewContextImpl.java:782) | |
at org.apache.myfaces.context.servlet.PartialViewContextImpl$PhaseAwareVisitCallback.visit(PartialViewContextImpl.java:743) | |
at org.apache.myfaces.component.visit.PartialVisitContext.invokeVisitCallback(PartialVisitContext.java:214) | |
at javax.faces.component.UIForm.visitTree(UIForm.java:323) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at javax.faces.component.UIComponent.visitTree(UIComponent.java:960) | |
at javax.faces.component.UIComponentBase.visitTree(UIComponentBase.java:1165) | |
at org.apache.myfaces.context.servlet.PartialViewContextImpl.processPartialRendering(PartialViewContextImpl.java:518) | |
at org.apache.myfaces.context.servlet.PartialViewContextImpl.processPartial(PartialViewContextImpl.java:405) | |
at javax.faces.context.PartialViewContextWrapper.processPartial(PartialViewContextWrapper.java:88) | |
at javax.faces.context.PartialViewContextWrapper.processPartial(PartialViewContextWrapper.java:88) | |
at javax.faces.component.UIViewRoot.encodeChildren(UIViewRoot.java:408) | |
at javax.faces.component.UIComponentBase.encodeAll(UIComponentBase.java:530) | |
at org.apache.myfaces.view.facelets.FaceletViewDeclarationLanguage.renderView(FaceletViewDeclarationLanguage.java:1981) | |
at org.apache.myfaces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:285) | |
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) | |
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:59) | |
at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:116) | |
at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:241) | |
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:199) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.omnifaces.filter.GzipResponseFilter.doFilter(GzipResponseFilter.java:148) | |
at org.omnifaces.filter.HttpFilter.doFilter(HttpFilter.java:75) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at pf.LoginFilter.doFilter(LoginFilter.java:194) | |
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) | |
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) | |
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) | |
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) | |
at org.apache.tomee.catalina.OpenEJBValve.invoke(OpenEJBValve.java:45) | |
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) | |
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) | |
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) | |
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931) | |
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) | |
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) | |
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) | |
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) | |
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312) | |
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) | |
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) | |
at java.lang.Thread.run(Thread.java:722) | |
Caused by: javax.persistence.PersistenceException: Query failed | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.buildResultSet(QueryImpl.java:307) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.getResultListImpl(QueryImpl.java:819) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.getResultList(QueryImpl.java:775) | |
at jpa.session.OrdersFacade.getOrdersForAuditTrail(OrdersFacade.java:722) | |
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.cdi.CdiInterceptor.invoke(CdiInterceptor.java:128) | |
at org.apache.openejb.cdi.CdiInterceptor.access$000(CdiInterceptor.java:43) | |
at org.apache.openejb.cdi.CdiInterceptor$1.call(CdiInterceptor.java:64) | |
at org.apache.openejb.cdi.CdiInterceptor.aroundInvoke(CdiInterceptor.java:70) | |
at sun.reflect.GeneratedMethodAccessor120.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.monitoring.StatsInterceptor.record(StatsInterceptor.java:176) | |
at org.apache.openejb.monitoring.StatsInterceptor.invoke(StatsInterceptor.java:95) | |
at sun.reflect.GeneratedMethodAccessor119.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:181) | |
at org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:163) | |
at org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:138) | |
at org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:237) | |
at org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:189) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.synchronizedBusinessMethod(EjbObjectProxyHandler.java:253) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:248) | |
at org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:92) | |
at org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:279) | |
... 99 more | |
Caused by: java.sql.SQLSyntaxErrorException: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedPreparedStatement40.<init>(Unknown Source) | |
at org.apache.derby.jdbc.Driver40.newEmbedPreparedStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.tomcat.jdbc.pool.ProxyConnection.invoke(ProxyConnection.java:126) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.interceptor.AbstractCreateStatementInterceptor.invoke(AbstractCreateStatementInterceptor.java:67) | |
at org.apache.tomcat.jdbc.pool.interceptor.StatementCache.invoke(StatementCache.java:172) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.TrapException.invoke(TrapException.java:41) | |
at org.apache.tomcat.jdbc.pool.JdbcInterceptor.invoke(JdbcInterceptor.java:109) | |
at org.apache.tomcat.jdbc.pool.DisposableConnectionFacade.invoke(DisposableConnectionFacade.java:80) | |
at $Proxy105.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.tomee.jdbc.TomEEDataSourceCreator$ContantHashCodeHandler.invoke(TomEEDataSourceCreator.java:319) | |
at $Proxy140.prepareStatement(Unknown Source) | |
at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source) | |
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
at java.lang.reflect.Method.invoke(Method.java:601) | |
at org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invokeUnderTransaction(ManagedConnection.java:151) | |
at org.apache.openejb.resource.jdbc.managed.local.ManagedConnection.invoke(ManagedConnection.java:117) | |
at $Proxy140.prepareStatement(Unknown Source) | |
at org.batoo.jpa.jdbc.ConnectionProxy.prepareStatement(ConnectionProxy.java:375) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.buildResultSetImpl(QueryImpl.java:350) | |
at org.batoo.jpa.core.impl.criteria.QueryImpl.buildResultSet(QueryImpl.java:293) | |
... 131 more | |
Caused by: java.sql.SQLException: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) | |
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) | |
... 170 more | |
Caused by: ERROR 42879: The ORDER BY clause may not contain column 'CUSTOMER_NAME', since the query specifies DISTINCT and that column does not appear in the query result. | |
at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) | |
at org.apache.derby.impl.sql.compile.OrderByColumn.bindOrderByColumn(Unknown Source) | |
at org.apache.derby.impl.sql.compile.OrderByList.bindOrderByColumns(Unknown Source) | |
at org.apache.derby.impl.sql.compile.CursorNode.bindStatement(Unknown Source) | |
at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) | |
at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) | |
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) | |
... 164 more | |
pf_UsersController.logout(): administrator logged out at Tue Nov 27 02:18:59 EST 2012 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment