高手快来，奇怪问题

[mouer]

2009-07-20 17:23:45 ERROR [http-8080-Processor22] (BdSeeFilmDaoImpl.java:214) - org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 32 [select x.productElementID from (select distinct p.productElementID from com.ccit.netvirst.entity.Productelement p,com.ccit.netvirst.entity.PromixElement p1 where p.productElementID=p1.productElementID and p1.status='1' and p.cpid='11' and p.channelid in (select t.channelid from com.ccit.netvirst.entity.Channelinfo t start with t.channelid='222' connect by prior t.parentid=t.channelid)) x where 1=1 and x.productElementID='qqq']
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 32 [select x.productElementID from (select distinct p.productElementID from com.ccit.netvirst.entity.Productelement p,com.ccit.netvirst.entity.PromixElement p1 where p.productElementID=p1.productElementID and p1.status='1' and p.cpid='11' and p.channelid in (select t.channelid from com.ccit.netvirst.entity.Channelinfo t start with t.channelid='222' connect by prior t.parentid=t.channelid)) x where 1=1 and x.productElementID='qqq']
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:31)
at org.hibernate.hql.ast.QuerySyntaxException.convert(QuerySyntaxException.java:24)
at org.hibernate.hql.ast.ErrorCounter.throwQueryException(ErrorCounter.java:59)
at org.hibernate.hql.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:258)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:157)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
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 com.ccit.netvirst.dao.platform.BdSeeFilmDaoImpl.updateInfo(BdSeeFilmDaoImpl.java:180)
at com.ccit.netvirst.service.platform.BdSeeFilmServiceImpl.updateInfo(BdSeeFilmServiceImpl.java:87)
at com.ccit.netvirst.web.usermanage.userlogmgr.BdSeeFilmEditAction.execute(BdSeeFilmEditAction.java:62)
at com.ccit.netvirst.comm.util.BaseAction.execute(BaseAction.java:80)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at com.ccit.netvirst.comm.util.CharsetEncodingFilter.doFilter(CharsetEncodingFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Thread.java:595)

[yuwenbao]

晕死，你把oracle的递归查询语法用在hql上，怎么不报错啊，你得用纯sql

[叶涛网站推广优化]

select x.productElementID from (select distinct p.productElementID from com.ccit.netvirst.entity.Productelement p,com.ccit.netvirst.entity.PromixElement p1 where p.productElementID=p1.productElementID and p1.status='1' and p.cpid='11' and p.channelid in (select t.channelid from com.ccit.netvirst.entity.Channelinfo t start with t.channelid='222' connect by prior t.parentid=t.channelid)) x where 1=1 and x.productElementID='qqq']
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ( near line 1, column 32 [select x.productElementID from (select distinct p.productElementID from com.ccit.netvirst.entity.Productelement p,com.ccit.netvirst.entity.PromixElement p1 where p.productElementID=p1.productElementID and p1.status='1' and p.cpid='11' and p.channelid in (select t.channelid from com.ccit.netvirst.entity.Channelinfo t start with t.channelid='222' connect by prior t.parentid=t.channelid)) x where 1=1 and x.productElementID='qqq'



好强大

[zhaodalong]

好强大

[mouer]

倒~·知道了。。