7 Replies Latest reply on Jan 11, 2007 11:09 AM by andydale

    Same query doesn't work on jboss-4.0.5.GA

    hispeedsurfer

      Hi,

      Can someone tell me why a query in my webapp on jboss-4.0.4.GA runs successfully, but on jboss-4.0.5.GA the resultlist is empty.

      query= "from org.foo.Measurement where measure.sensor = true and id != 0 order by measure.typ"

      @In(create=true)
      ...
       private EntityManager em;
      ...
       liste = em.createQuery(query).getResultList();
      


      component.xml
      <component name="em" class="org.jboss.seam.core.ManagedPersistenceContext">
       <property name="persistenceUnitJndiName">
       java:/EntityManagerFactories/boschMmdData
       </property>
       </component>
      


      All libraries on jboss the same, the database too.

      Thanks
      andi



        • 1. Re: Same query doesn't work on jboss-4.0.5.GA
          hispeedsurfer

          additional info.


          same app.ear deployed on both servers.
          database: mysql (xampp)
          entities mapped to database an filled with values
          other lists from database tables are displayed in my app
          mysql libraries placed in lib jbossas/server/default/lib


          only on the new server the getResultList() is empty - but why?

          Thanks
          Andreas

          • 2. Re: Same query doesn't work on jboss-4.0.5.GA
            hispeedsurfer

            Is there an other configuration on jboss-4.0.5.GA as on jboss-4.0.4.GA for peristance access or what the problem

            here the stack trace


            08:31:52,743 ERROR [STDERR] java.lang.NullPointerException
            08:31:52,743 ERROR [STDERR] at org.hibernate.hql.ast.tree.FromClause.findIntendedAliasedFromElementBasedOnCrazyJPARequirements(FromClause.java:120)
            08:31:52,759 ERROR [STDERR] at org.hibernate.hql.ast.tree.FromClause.containsClassAlias(FromClause.java:247)
            08:31:52,759 ERROR [STDERR] at org.hibernate.hql.ast.tree.FromClause.isFromElementAlias(FromClause.java:135)
            08:31:52,759 ERROR [STDERR] at org.hibernate.hql.ast.HqlSqlWalker.isNonQualifiedPropertyRef(HqlSqlWalker.java:474)
            08:31:52,759 ERROR [STDERR] at org.hibernate.hql.antlr.HqlSqlBaseWalker.addrExpr(HqlSqlBaseWalker.java:4382)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.antlr.HqlSqlBaseWalker.addrExprLhs(HqlSqlBaseWalker.java:4830)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.antlr.HqlSqlBaseWalker.addrExpr(HqlSqlBaseWalker.java:4311)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1212)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.antlr.HqlSqlBaseWalker.orderExprs(HqlSqlBaseWalker.java:1545)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.antlr.HqlSqlBaseWalker.orderExprs(HqlSqlBaseWalker.java:1639)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.antlr.HqlSqlBaseWalker.orderClause(HqlSqlBaseWalker.java:1521)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:622)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
            08:31:52,790 ERROR [STDERR] at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
            08:31:52,790 ERROR [STDERR] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
            08:31:52,790 ERROR [STDERR] at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
            08:31:52,790 ERROR [STDERR] at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
            08:31:52,790 ERROR [STDERR] at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
            08:31:52,806 ERROR [STDERR] at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
            08:31:52,806 ERROR [STDERR] at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
            08:31:52,806 ERROR [STDERR] at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:92)
            08:31:52,806 ERROR [STDERR] at de.beffo.seam.helper.SelectItemHelfer.listeHolen(SelectItemHelfer.java:139)
            08:31:52,806 ERROR [STDERR] at de.beffo.seam.helper.SelectItemHelfer.getSelectItemsMitBlank(SelectItemHelfer.java:112)
            08:31:52,806 ERROR [STDERR] at de.beffo.seam.helper.SelectItemHelfer$$FastClassByCGLIB$$bed44e52.invoke(<generated>)
            08:31:52,806 ERROR [STDERR] at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
            08:31:52,806 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:45)
            08:31:52,806 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:55)
            08:31:52,806 ERROR [STDERR] at org.jboss.seam.interceptors.OutcomeInterceptor.interceptOutcome(OutcomeInterceptor.java:23)
            08:31:52,806 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor943.invoke(Unknown Source)
            08:31:52,806 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:52,806 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:52,806 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:52,806 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:52,837 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:52,837 ERROR [STDERR] at org.jboss.seam.interceptors.RollbackInterceptor.rollbackIfNecessary(RollbackInterceptor.java:33)
            08:31:52,837 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor956.invoke(Unknown Source)
            08:31:52,837 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:52,837 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:52,837 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:52,837 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:52,837 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:52,837 ERROR [STDERR] at org.jboss.seam.interceptors.BijectionInterceptor.bijectTargetComponent(BijectionInterceptor.java:51)
            08:31:52,852 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor945.invoke(Unknown Source)
            08:31:52,852 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:52,852 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:52,852 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:52,852 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:52,852 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:52,852 ERROR [STDERR] at org.jboss.seam.interceptors.ConversationInterceptor.endOrBeginLongRunningConversation(ConversationInterceptor.java:51)
            08:31:52,852 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor942.invoke(Unknown Source)
            08:31:52,852 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:52,852 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:52,852 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:52,852 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:52,852 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:52,852 ERROR [STDERR] at org.jboss.seam.interceptors.ExceptionInterceptor.handleExceptions(ExceptionInterceptor.java:38)
            08:31:52,852 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor939.invoke(Unknown Source)
            08:31:52,852 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:52,868 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.interceptors.SynchronizationInterceptor.serialize(SynchronizationInterceptor.java:30)
            08:31:52,868 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor944.invoke(Unknown Source)
            08:31:52,868 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:52,868 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.createSeamInvocationContext(RootInterceptor.java:144)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invokeInContexts(RootInterceptor.java:129)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:102)
            08:31:52,868 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:144)
            08:31:52,931 ERROR [STDERR] at org.jboss.seam.intercept.JavaBeanInterceptor.intercept(JavaBeanInterceptor.java:79)
            08:31:52,931 ERROR [STDERR] at de.beffo.seam.helper.SelectItemHelfer$$EnhancerByCGLIB$$88bc263e.getSelectItemsMitBlank(<generated>)
            08:31:52,931 ERROR [STDERR] at de.bosch.ccecp.mmd.action.MessketteEditorBean.getAlleSensorenMitBlank(MessketteEditorBean.java:62)
            08:31:52,931 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            08:31:52,931 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            08:31:52,931 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:52,931 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:52,931 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
            08:31:52,931 ERROR [STDERR] at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
            08:31:52,931 ERROR [STDERR] at org.jboss.seam.intercept.EJBInvocationContext.proceed(EJBInvocationContext.java:37)
            08:31:52,931 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:55)
            08:31:52,946 ERROR [STDERR] at org.jboss.seam.interceptors.BijectionInterceptor.bijectTargetComponent(BijectionInterceptor.java:51)
            08:31:52,946 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor945.invoke(Unknown Source)
            08:31:52,946 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:52,946 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:52,946 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:52,946 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:52,946 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:52,946 ERROR [STDERR] at org.jboss.seam.interceptors.ManagedEntityIdentityInterceptor.aroundInvoke(ManagedEntityIdentityInterceptor.java:39)
            08:31:52,946 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor954.invoke(Unknown Source)
            08:31:52,946 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:52,946 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:52,946 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:52,946 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:52,946 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:52,946 ERROR [STDERR] at org.jboss.seam.interceptors.OutcomeInterceptor.interceptOutcome(OutcomeInterceptor.java:23)
            08:31:52,946 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor943.invoke(Unknown Source)
            08:31:52,993 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:53,009 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:53,009 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:53,009 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:53,009 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:53,009 ERROR [STDERR] at org.jboss.seam.interceptors.ConversationInterceptor.endOrBeginLongRunningConversation(ConversationInterceptor.java:51)
            08:31:53,009 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor942.invoke(Unknown Source)
            08:31:53,009 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:53,009 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:53,009 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:53,009 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:53,009 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:53,009 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.createSeamInvocationContext(RootInterceptor.java:144)
            08:31:53,009 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invokeInContexts(RootInterceptor.java:129)
            08:31:53,024 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:102)
            08:31:53,024 ERROR [STDERR] at org.jboss.seam.intercept.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:49)
            08:31:53,024 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor941.invoke(Unknown Source)
            08:31:53,024 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:53,024 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:53,024 ERROR [STDERR] at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
            08:31:53,024 ERROR [STDERR] at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
            08:31:53,024 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            08:31:53,024 ERROR [STDERR] at org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor.invoke(ExtendedPersistenceContextPropagationInterceptor.java:57)
            08:31:53,024 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            08:31:53,024 ERROR [STDERR] at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
            08:31:53,024 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            08:31:53,024 ERROR [STDERR] at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:46)
            08:31:53,024 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            08:31:53,040 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInNoTx(TxPolicy.java:66)
            08:31:53,040 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$NotSupported.invoke(TxInterceptor.java:102)
            08:31:53,040 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            08:31:53,040 ERROR [STDERR] at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
            08:31:53,040 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            08:31:53,040 ERROR [STDERR] at org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:83)
            08:31:53,040 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            08:31:53,040 ERROR [STDERR] at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
            08:31:53,040 ERROR [STDERR] at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:102)
            08:31:53,040 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            08:31:53,040 ERROR [STDERR] at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
            08:31:53,040 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            08:31:53,040 ERROR [STDERR] at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
            08:31:53,040 ERROR [STDERR] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
            08:31:53,040 ERROR [STDERR] at org.jboss.ejb3.stateful.StatefulContainer.localInvoke(StatefulContainer.java:203)
            08:31:53,087 ERROR [STDERR] at org.jboss.ejb3.stateful.StatefulLocalProxy.invoke(StatefulLocalProxy.java:98)
            08:31:53,087 ERROR [STDERR] at $Proxy760.getAlleSensorenMitBlank(Unknown Source)
            08:31:53,087 ERROR [STDERR] at de.bosch.ccecp.mmd.action.MessketteEditor$$FastClassByCGLIB$$aab4245e.invoke(<generated>)
            08:31:53,087 ERROR [STDERR] at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
            08:31:53,087 ERROR [STDERR] at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:45)
            08:31:53,087 ERROR [STDERR] at org.jboss.seam.intercept.ClientSideInterceptor$1.proceed(ClientSideInterceptor.java:73)
            08:31:53,087 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:55)
            08:31:53,102 ERROR [STDERR] at org.jboss.seam.interceptors.RemoveInterceptor.removeIfNecessary(RemoveInterceptor.java:39)
            08:31:53,102 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor940.invoke(Unknown Source)
            08:31:53,102 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:53,102 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:53,102 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:53,102 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:53,102 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:53,102 ERROR [STDERR] at org.jboss.seam.interceptors.ExceptionInterceptor.handleExceptions(ExceptionInterceptor.java:38)
            08:31:53,102 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor939.invoke(Unknown Source)
            08:31:53,102 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:53,102 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:53,102 ERROR [STDERR] at org.jboss.seam.util.Reflections.invoke(Reflections.java:18)
            08:31:53,102 ERROR [STDERR] at org.jboss.seam.intercept.Interceptor.aroundInvoke(Interceptor.java:169)
            08:31:53,102 ERROR [STDERR] at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:64)
            08:31:53,102 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.createSeamInvocationContext(RootInterceptor.java:144)
            08:31:53,102 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invokeInContexts(RootInterceptor.java:129)
            08:31:53,118 ERROR [STDERR] at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:102)
            08:31:53,118 ERROR [STDERR] at org.jboss.seam.intercept.ClientSideInterceptor.interceptInvocation(ClientSideInterceptor.java:82)
            08:31:53,118 ERROR [STDERR] at org.jboss.seam.intercept.ClientSideInterceptor.intercept(ClientSideInterceptor.java:51)
            08:31:53,118 ERROR [STDERR] at org.jboss.seam.intercept.Proxy$$EnhancerByCGLIB$$37f18469.getAlleSensorenMitBlank(<generated>)
            08:31:53,118 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            08:31:53,118 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            08:31:53,118 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            08:31:53,118 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
            08:31:53,118 ERROR [STDERR] at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:438)
            08:31:53,118 ERROR [STDERR] at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:82)
            08:31:53,118 ERROR [STDERR] at com.sun.facelets.el.LegacyELContext$LegacyELResolver.getValue(LegacyELContext.java:141)
            08:31:53,118 ERROR [STDERR] at com.sun.el.parser.AstValue.getValue(AstValue.java:96)
            08:31:53,118 ERROR [STDERR] at com.sun.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:183)
            08:31:53,118 ERROR [STDERR] at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:71)
            08:31:53,134 ERROR [STDERR] at com.sun.facelets.el.LegacyValueBinding.getValue(LegacyValueBinding.java:56)
            08:31:53,134 ERROR [STDERR] at javax.faces.component.UISelectItems.getValue(UISelectItems.java:55)
            08:31:53,134 ERROR [STDERR] at org.apache.myfaces.shared_impl.util.SelectItemsIterator.hasNext(SelectItemsIterator.java:102)
            08:31:53,134 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.RendererUtils.internalGetSelectItemList(RendererUtils.java:477)
            08:31:53,134 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.RendererUtils.getSelectItemList(RendererUtils.java:453)
            08:31:53,134 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.html.HtmlRendererUtils.internalRenderSelect(HtmlRendererUtils.java:278)
            08:31:53,134 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.html.HtmlRendererUtils.renderMenu(HtmlRendererUtils.java:252)
            08:31:53,134 ERROR [STDERR] at org.apache.myfaces.shared_impl.renderkit.html.HtmlMenuRendererBase.encodeEnd(HtmlMenuRendererBase.java:54)
            08:31:53,134 ERROR [STDERR] at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:536)
            08:31:53,134 ERROR [STDERR] at org.ajax4jsf.framework.renderer.RendererBase.renderChild(RendererBase.java:249)
            08:31:53,134 ERROR [STDERR] at org.ajax4jsf.framework.renderer.RendererBase.renderChildren(RendererBase.java:225)
            08:31:53,134 ERROR [STDERR] at org.ajax4jsf.framework.renderer.AjaxContainerRenderer.encodeChildren(AjaxContainerRenderer.java:88)
            08:31:53,134 ERROR [STDERR] at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:524)
            08:31:53,134 ERROR [STDERR] at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java:234)
            08:31:53,181 ERROR [STDERR] at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java:239)
            08:31:53,181 ERROR [STDERR] at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java:239)
            08:31:53,181 ERROR [STDERR] at com.sun.facelets.tag.jsf.ComponentSupport.encodeRecursive(ComponentSupport.java:239)
            08:31:53,181 ERROR [STDERR] at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:580)
            08:31:53,181 ERROR [STDERR] at org.ajax4jsf.framework.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:101)
            08:31:53,181 ERROR [STDERR] at org.ajax4jsf.framework.ajax.AjaxViewHandler.renderView(AjaxViewHandler.java:222)
            08:31:53,196 ERROR [STDERR] at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:384)
            08:31:53,196 ERROR [STDERR] at javax.faces.webapp.FacesServlet.service(FacesServlet.java:138)
            08:31:53,196 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
            08:31:53,196 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            08:31:53,196 ERROR [STDERR] at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:144)
            08:31:53,196 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
            08:31:53,196 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            08:31:53,196 ERROR [STDERR] at org.jboss.seam.servlet.SeamExceptionFilter.doFilter(SeamExceptionFilter.java:46)
            08:31:53,196 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
            08:31:53,196 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            08:31:53,196 ERROR [STDERR] at org.jboss.seam.servlet.SeamRedirectFilter.doFilter(SeamRedirectFilter.java:32)
            08:31:53,196 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
            08:31:53,196 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            08:31:53,196 ERROR [STDERR] at org.ajax4jsf.framework.ajax.xmlfilter.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:75)
            08:31:53,259 ERROR [STDERR] at org.ajax4jsf.framework.ajax.xmlfilter.BaseFilter.doFilter(BaseFilter.java:213)
            08:31:53,259 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
            08:31:53,259 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            08:31:53,259 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
            08:31:53,259 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
            08:31:53,259 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
            08:31:53,259 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
            08:31:53,259 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
            08:31:53,259 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
            08:31:53,274 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
            08:31:53,274 ERROR [STDERR] at org.jboss.web.tomcat.security.HttpServletRequestResponseValve.invoke(HttpServletRequestResponseValve.java:70)
            08:31:53,274 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
            08:31:53,274 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
            08:31:53,274 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
            08:31:53,274 ERROR [STDERR] at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:156)
            08:31:53,274 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
            08:31:53,274 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
            08:31:53,274 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
            08:31:53,274 ERROR [STDERR] at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
            08:31:53,274 ERROR [STDERR] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
            08:31:53,274 ERROR [STDERR] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
            08:31:53,274 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
            


            Any ideas

            Thanks
            andreas

            • 3. Re: Same query doesn't work on jboss-4.0.5.GA
              andydale

              Hi Andreas,

              I think this is a problem with the newer version (3.2.0.GA) of hibernate that ships with 4.0.5GA.

              I had a query that worked with Hibernate version 3.2.0CR2 but on "upgrading" to the final release the query did not work, because i was also getting a null pointer exception (exactly the same as yours). There is a bug for it in the Hibernate JIRA http://opensource.atlassian.com/projects/hibernate/browse/HHH-2159, it is a really simple fix if you want to do it yourself.

              Here is the link to the thread on the hibernate forum http://forum.hibernate.org/viewtopic.php?t=966031&highlight=breaks.

              Also please vote for the bug as well.

              Cheers,

              Andy

              • 4. Re: Same query doesn't work on jboss-4.0.5.GA
                hispeedsurfer

                Hi Andy,

                thank you for response.

                Can you tell me in few words what I have to do build a hibernate.jar with modified FromClause.java?

                hibernate-3.2.1.ga.zip I have allready downloaded. Ant and JDK is installed.



                Thanks
                Andreas

                • 5. Re: Same query doesn't work on jboss-4.0.5.GA
                  hispeedsurfer

                  Ok it works!!!!
                  Thanks to andydale.

                  First I extracted hibernate-3.2.0.ga.zip. From the hibernate directory with ant I executed with 5 errors.
                  Then I have copied the directory to eclipse workspace and make a new project from existing ant. build.xml -> Run as ant build: Error.

                  Now from workspace/hibernate directory I started ant from console over again. Yeaaah

                  And the query execute successful!!!

                  Is there a easier way to get this started?


                  Thanks
                  andreas

                  • 6. Re: Same query doesn't work on jboss-4.0.5.GA
                    andydale

                    Hi Andreas,

                    First off you need to open the offending class (org.hibernate.hql.ast.tree.FromClause) and then locate addDuplicateAlias method, and then just put the fromElementByClassAlias.put( alias, element ); call into an if statement like so:

                    void addDuplicateAlias(String alias, FromElement element) {
                     if(alias != null) {
                     fromElementByClassAlias.put( alias, element );
                     }
                    }
                    

                    This solution has not been verified by the hibernate people, but if you look in the method above addDuplicateAlias(registerFromElement) they always perform the hashmap.put() calls in an if statement checking that the "key" (classAlias) is not null. This got rid of my problem, hopefully it should do the same for you.

                    After you have modified the source, rebuild with ant, i would use the target "jar" or "dist"

                    Let me know how you get on with it.

                    Cheers,

                    Andy

                    • 7. Re: Same query doesn't work on jboss-4.0.5.GA
                      andydale

                      seems like you managed it :-)

                      I did not manage to get it to buiild via ant from eclipse. I also got some other error with the junit tasks in the build file, but running "ant jar" or "ant dist" work fine

                      Andy