[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-4481) org.hibernate.QueryException: query must begin with SELECT or FROM: update
Paul Benedict (JIRA)
noreply at atlassian.com
Thu Oct 8 02:49:41 EDT 2009
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-4481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=34134#action_34134 ]
Paul Benedict commented on HHH-4481:
------------------------------------
This issue has a poor description. Regardless, the HQL manual does say:
http://docs.jboss.org/hibernate/stable/core/reference/en/html/queryhql.html#queryhql-bulk
14.15. Bulk update and delete
HQL now supports update, delete and insert ... select ... statements.
Perhaps the new syntax is not supported in externalized HQL. Your workaround would be to move it out of the Hibernate configuration.
> org.hibernate.QueryException: query must begin with SELECT or FROM: update
> ---------------------------------------------------------------------------
>
> Key: HHH-4481
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4481
> Project: Hibernate Core
> Issue Type: Bug
> Components: core
> Affects Versions: 3.3.1
> Environment: struts and Hibernate
> Reporter: venkata rajesh
>
> org.hibernate.QueryException: query must begin with SELECT or FROM: update
> org.hibernate.QueryException: query must begin with SELECT or FROM: update [update com.cmsstruts.hibernate.Pojos.Session set Outtime = :Outtime where Rand = :Rand]
> at org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:83)
> at org.hibernate.hql.classic.PreprocessingParser.token(PreprocessingParser.java:108)
> at org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:28)
> at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:178)
> at org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:154)
> at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75)
> at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
> at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
> at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:134)
> at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:113)
> at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1600)
> at com.cmsstrus.hibernate.utils.DataObject.sessionUtilities(DataObject.java:1523)
> at ui.Utilities.SessionMgmt(Utilities.java:53)
> at org.apache.jsp.jsp.success_jsp._jspService(org.apache.jsp.jsp.success_jsp:72)
> at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
> at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
> at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
> at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
> at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
> at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
> at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
> at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
> at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
> at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
> at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
> 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:709)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> 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.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> at java.lang.Thread.run(Thread.java:619)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list