You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@myfaces.apache.org by Vasista <rb...@gmail.com> on 2007/10/03 15:12:29 UTC
Getting Error While retreiving Hibernate Query Result in View Layer
Using Trinidad
Hi All,
I am doing my application with Hibernate, Spring and Trinidad. I am
using <prop
key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>
property in my spring-context.xml file {Spring Configuration file} For
Hibernate Query to work with Trinidad. The other factory class property
<prop
key="hibernate.query.factory_class">org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop>
is not working with view Layer [Trinidad].
My question is.... When ever I am having a HQL with case when...else...end
condition. The query is working fine upto Spring Layer. But In view Layer
with Trinidad, I am getting following error.
org.hibernate.QueryException: undefined alias: CASE [SELECT CASE WHEN x.ID
IS NULL THEN x.name ELSE x.desc END FROM X x
at
org.hibernate.hql.classic.PathExpressionParser.token(PathExpressionParser.java:130)
at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:28)
at org.hibernate.hql.classic.SelectParser.token(SelectParser.java:176)
at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:86)
at org.hibernate.hql.classic.ClauseParser.end(ClauseParser.java:113)
at
org.hibernate.hql.classic.PreprocessingParser.end(PreprocessingParser.java:122)
at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:29)
at
org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:216)
at
org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:185)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at
org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at
org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at
org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke(HibernateTemplate.java:1192)
at $Proxy1.createQuery(Unknown Source)
at com.knoahsoft.util.hibernate.QueryUtilH.getList(QueryUtilH.java:64)
at
com.knoahsoft.daoimpl.inbox.SystemInboxDataImpl.getSyetTobeDistributedData(SystemInboxDataImpl.java:254)
at
com.knoahsoft.daosupportimpl.inbox.SystemInboxDaoDataImpl$4.doInHibernate(SystemInboxDaoDataImpl.java:223)
at
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:362)
at
org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:332)
at
com.knoahsoft.daosupportimpl.inbox.SystemInboxDaoDataImpl.loadSyetTobeDistributedData(SystemInboxDaoDataImpl.java:220)
at
com.knoahsoft.serviceimpl.inbox.SystemInboxServiceImpl.getSyetTobeDistributedDataService(SystemInboxServiceImpl.java:368)
at
com.knoahsoft.factory.inbox.SystemInboxServiceFactory.getSyetTobeDistributedDataService(SystemInboxServiceFactory.java:69)
at
com.knoahsoft.client.inbox.SystemInbox.managerToBeDistributedNavItem_Action(SystemInbox.java:213)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:72)
at
org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:154)
at
org.apache.myfaces.trinidad.component.UIXCollection.broadcast(UIXCollection.java:145)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:267)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:381)
at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:75)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
at
com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._invokeDoFilter(TrinidadFilterImpl.java:208)
at
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:165)
at
org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:138)
at
org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)
at
com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:622)
at
com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:369)
at
com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:865)
at
com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:447)
at
com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:215)
at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
at
com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
at
oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at
com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
Can AnyOne please look into the problem? and suggest some idea.
Thanks,
Bandaru
--
View this message in context: http://www.nabble.com/Getting-Error-While-retreiving-Hibernate-Query-Result-in-View-Layer-Using-Trinidad-tf4561719.html#a13018545
Sent from the MyFaces - Users mailing list archive at Nabble.com.
Re: Getting Error While retreiving Hibernate Query Result in View Layer Using Trinidad
Posted by Alonso Isidoro Roman <al...@gmail.com>.
could you paste Caused by in expeption?
2007/10/3, Vasista <rb...@gmail.com>:
>
>
> Hi All,
>
> I am doing my application with Hibernate, Spring and Trinidad. I am
> using <prop
> key="hibernate.query.factory_class">
> org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>
> property in my spring-context.xml file {Spring Configuration file} For
> Hibernate Query to work with Trinidad. The other factory class property
> <prop
> key="hibernate.query.factory_class">
> org.hibernate.hql.ast.ASTQueryTranslatorFactory</prop>
> is not working with view Layer [Trinidad].
>
> My question is.... When ever I am having a HQL with case when...else...end
> condition. The query is working fine upto Spring Layer. But In view Layer
> with Trinidad, I am getting following error.
>
> org.hibernate.QueryException: undefined alias: CASE [SELECT CASE WHEN x.ID
> IS NULL THEN x.name ELSE x.desc END FROM X x
> at
> org.hibernate.hql.classic.PathExpressionParser.token(
> PathExpressionParser.java:130)
> at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java
> :28)
> at org.hibernate.hql.classic.SelectParser.token(SelectParser.java
> :176)
> at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java
> :86)
> at org.hibernate.hql.classic.ClauseParser.end(ClauseParser.java
> :113)
> at
> org.hibernate.hql.classic.PreprocessingParser.end(PreprocessingParser.java
> :122)
> at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java
> :29)
> at
> org.hibernate.hql.classic.QueryTranslatorImpl.compile(
> QueryTranslatorImpl.java:216)
> at
> org.hibernate.hql.classic.QueryTranslatorImpl.compile(
> QueryTranslatorImpl.java:185)
> at org.hibernate.engine.query.HQLQueryPlan.<init>(
> HQLQueryPlan.java:77)
> at org.hibernate.engine.query.HQLQueryPlan.<init>(
> HQLQueryPlan.java:56)
> at
> org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(
> QueryPlanCache.java:72)
> at
> org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(
> AbstractSessionImpl.java:133)
> at
> org.hibernate.impl.AbstractSessionImpl.createQuery(
> AbstractSessionImpl.java:112)
> at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java
> :1623)
> at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
>
> org.springframework.orm.hibernate3.HibernateTemplate$CloseSuppressingInvocationHandler.invoke
> (HibernateTemplate.java:1192)
> at $Proxy1.createQuery(Unknown Source)
> at com.knoahsoft.util.hibernate.QueryUtilH.getList(QueryUtilH.java
> :64)
> at
> com.knoahsoft.daoimpl.inbox.SystemInboxDataImpl.getSyetTobeDistributedData
> (SystemInboxDataImpl.java:254)
> at
> com.knoahsoft.daosupportimpl.inbox.SystemInboxDaoDataImpl$4.doInHibernate(
> SystemInboxDaoDataImpl.java:223)
> at
> org.springframework.orm.hibernate3.HibernateTemplate.execute(
> HibernateTemplate.java:362)
> at
> org.springframework.orm.hibernate3.HibernateTemplate.executeFind(
> HibernateTemplate.java:332)
> at
>
> com.knoahsoft.daosupportimpl.inbox.SystemInboxDaoDataImpl.loadSyetTobeDistributedData
> (SystemInboxDaoDataImpl.java:220)
> at
>
> com.knoahsoft.serviceimpl.inbox.SystemInboxServiceImpl.getSyetTobeDistributedDataService
> (SystemInboxServiceImpl.java:368)
> at
>
> com.knoahsoft.factory.inbox.SystemInboxServiceFactory.getSyetTobeDistributedDataService
> (SystemInboxServiceFactory.java:69)
> at
>
> com.knoahsoft.client.inbox.SystemInbox.managerToBeDistributedNavItem_Action
> (SystemInbox.java:213)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java
> :39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at com.sun.faces.el.MethodBindingImpl.invoke(
> MethodBindingImpl.java:126)
> at
> com.sun.faces.application.ActionListenerImpl.processAction(
> ActionListenerImpl.java:72)
> at
> org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java
> :154)
> at
> org.apache.myfaces.trinidad.component.UIXCollection.broadcast(
> UIXCollection.java:145)
> at javax.faces.component.UIViewRoot.broadcastEvents(
> UIViewRoot.java:267)
> at javax.faces.component.UIViewRoot.processApplication(
> UIViewRoot.java:381)
> at
> com.sun.faces.lifecycle.InvokeApplicationPhase.execute(
> InvokeApplicationPhase.java:75)
> at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java
> :200)
> at com.sun.faces.lifecycle.LifecycleImpl.execute(
> LifecycleImpl.java:90)
> at javax.faces.webapp.FacesServlet.service(FacesServlet.java:197)
> at
> com.evermind.server.http.ResourceFilterChain.doFilter(
> ResourceFilterChain.java:64)
> at
>
> org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._invokeDoFilter
> (TrinidadFilterImpl.java:208)
> at
>
> org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl
> (TrinidadFilterImpl.java:165)
> at
> org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(
> TrinidadFilterImpl.java:138)
> at
> org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(
> TrinidadFilter.java:92)
> at
> com.evermind.server.http.ServletRequestDispatcher.invoke(
> ServletRequestDispatcher.java:622)
> at
> com.evermind.server.http.ServletRequestDispatcher.forwardInternal(
> ServletRequestDispatcher.java:369)
> at
> com.evermind.server.http.HttpRequestHandler.doProcessRequest(
> HttpRequestHandler.java:865)
> at
> com.evermind.server.http.HttpRequestHandler.processRequest(
> HttpRequestHandler.java:447)
> at
> com.evermind.server.http.HttpRequestHandler.serveOneRequest(
> HttpRequestHandler.java:215)
> at
> com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java
> :117)
> at
> com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java
> :110)
> at
> oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(
> ServerSocketReadHandler.java:260)
> at
> com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(
> ReleasableResourcePooledExecutor.java:303)
> at java.lang.Thread.run(Thread.java:619)
>
>
> Can AnyOne please look into the problem? and suggest some idea.
>
> Thanks,
> Bandaru
>
> --
> View this message in context:
> http://www.nabble.com/Getting-Error-While-retreiving-Hibernate-Query-Result-in-View-Layer-Using-Trinidad-tf4561719.html#a13018545
> Sent from the MyFaces - Users mailing list archive at Nabble.com.
>
>
--
Alonso Isidoro Roman.