[jboss-user] [EJB 3.0] - Re: totally weird error: org.hibernate.hql.ast.tree.FromClau

[andydale]

I also had this problem after upgrading to the latest release of Hibernate 
(3.2.0GA).  I was experiencing the this exception when trying query a single 
table inheritence structure.

The following query did not work


  | Query tmpQuery = mEntityManager.createQuery(SELECT DISTINCT e.expression 
FROM TargetEntity  +
  | t INNER JOIN t.expressionTargets e LEFT OUTER JOIN FETCH 
e.expression.restrictions r  +
  | JOIN FETCH r.expressionTargets f JOIN FETCH f.targetEntity 
 +
  | WHERE t.id = :pk AND e.expression.class = 
Rule).setParameter(pk, 1); 
  | 

but the following one did


  | Query tmpQuery = mEntityManager.createQuery(SELECT DISTINCT e.expression 
FROM TargetEntity  +
  | t INNER JOIN t.expressionTargets e LEFT OUTER JOIN FETCH 
e.expression.restrictions r  +
  | JOIN FETCH r.expressionTargets f JOIN FETCH f.targetEntity 
 +
  | WHERE t.id = :pk AND e.expression.class = 
'rule').setParameter(pk, 1); 
  | 

I had to quote the discriminator value in the query, if this was not done it 
caused a NPE.

Cheers,

Andy

View the original post : 
http://www.jboss.com/index.html?module=bbop=viewtopicp=3979988#3979988

Reply to the post : 
http://www.jboss.com/index.html?module=bbop=postingmode=replyp=3979988
___
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

[jboss-user] [EJB 3.0] - Re: totally weird error: org.hibernate.hql.ast.tree.FromClau

[wink]

I get the same exception when I patched rc9, 
and it can work well in rc8.
anonymous wrote : 
  | em.createQuery(select sue.sysCode.codeId,  +
  | sue.password, sue.sysCode.state, 
sue.sysCode.codeContent, sue.employeeId  +
  | from SysUserEntity sue  +
  | where sue.sysCode.codeName = ?1)
  | .setParameter(1, loginName)
  | .getResultList();
  | 

anonymous wrote : 
  | javax.ejb.EJBException: java.lang.NullPointerException
  | at 
org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:69)
  | at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83)
  | at 
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:197)
  | at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at 
org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
  | at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at 
org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:83)
  | at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at 
org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:78)
  | at 
org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:131)
  | at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at 
org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:47)
  | at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at 
org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
  | at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at 
org.jboss.ejb3.stateful.StatefulContainer.dynamicInvoke(StatefulContainer.java:319)
  | at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)
  | at 
org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
  | at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:828)
  | at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:681)
  | at 
org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:358)
  | at 
org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:412)
  | at 
org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:239)
  | at 
org.jboss.remoting.RemoteClientInvoker.invoke(RemoteClientInvoker.java:190)
  | at org.jboss.remoting.Client.invoke(Client.java:525)
  | at org.jboss.remoting.Client.invoke(Client.java:488)
  | at 
org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:55)
  | at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at 
org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(ClientTxPropagationInterceptor.java:61)
  | at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at 
org.jboss.aspects.security.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:55)
  | at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at 
org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:77)
  | at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
  | at 
org.jboss.ejb3.stateful.StatefulRemoteProxy.invoke(StatefulRemoteProxy.java:133)
  | at $Proxy251.login(Unknown Source)
  | at 
ndtv.boss.common.web.security.SecurityDelegate.login(SecurityDelegate.java:41)
  | at ndtv.boss.common.web.security.Login_do.doPost(Login_do.java:49)
  | at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
  | at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
  | at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
  | at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  | at 
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
  | at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
  | at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
  | at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
  | at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
  | at 
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
  | at