org.hibernate.QueryException: query must begin with SELECT or FROM: update [update com.cmsstruts.hibernate.Pojos.Session set Outtime = :Outtime where Rand = :Rand]

Hibernate JIRA | venkata rajesh | 7 years ago
  1. 0

    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)

    Hibernate JIRA | 7 years ago | venkata rajesh
    org.hibernate.QueryException: query must begin with SELECT or FROM: update [update com.cmsstruts.hibernate.Pojos.Session set Outtime = :Outtime where Rand = :Rand]
  2. 0

    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)

    Hibernate JIRA | 7 years ago | venkata rajesh
    org.hibernate.QueryException: query must begin with SELECT or FROM: update [update com.cmsstruts.hibernate.Pojos.Session set Outtime = :Outtime where Rand = :Rand]
  3. 0

    [LPS-4190] undefined alias: com [SELECT wsrpConsumerPortlet FROM com.liferay.wsrp.model.WSRPConsumerPortlet wsrpConsumerPortlet ORDER BY wsrpConsumerPortlet.name ASC] - Liferay Issues

    liferay.com | 1 year ago
    com.liferay.portal.SystemException: com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.QueryException: undefined alias: com
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    I can't make a inner join between two tables in hibernate hql query

    Stack Overflow | 5 years ago | alin
    org.hibernate.QueryException: outer or full join must be followed by path expression select p.idprodus, p.denumire, p.cantitate from sakila.entity.Produs p inner join Furnizor f on p.idfurn = f.idfurn at org.hibernate.hql.classic.FromParser.token(FromParser.java:170)
  6. 0

    OR 3.0.1 Report Editing

    oreports | 9 years ago | diaben
    org.hibernate.QueryException: query must begin with SELECT or FROM: DELETE \[DELETE org.efs.openreports.objects.ORTag orTag where orTag.objectId = ? and orTag.objectClass = ? and orTag.tagType = ? \]

    3 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. Hibernate
      SessionImpl.createQuery
      1. org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:83)
      2. org.hibernate.hql.classic.PreprocessingParser.token(PreprocessingParser.java:108)
      3. org.hibernate.hql.classic.ParserHelper.parse(ParserHelper.java:28)
      4. org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:178)
      5. org.hibernate.hql.classic.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:154)
      6. org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:75)
      7. org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:54)
      8. org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:71)
      9. org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:134)
      10. org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:113)
      11. org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1600)
      11 frames
    3. com.cmsstrus.hibernate
      DataObject.sessionUtilities
      1. com.cmsstrus.hibernate.utils.DataObject.sessionUtilities(DataObject.java:1523)
      1 frame
    4. ui
      Utilities.SessionMgmt
      1. ui.Utilities.SessionMgmt(Utilities.java:53)
      1 frame
    5. org.apache.jsp
      success_jsp._jspService
      1. org.apache.jsp.jsp.success_jsp._jspService(org.apache.jsp.jsp.success_jsp:72)
      1 frame
    6. GWT dev
      HttpJspBase.service
      1. org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
      1 frame
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      1 frame
    8. GWT dev
      JspServlet.service
      1. org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
      2. org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
      3. org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
      3 frames
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      1 frame
    10. Glassfish Core
      ApplicationDispatcher.forward
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      3. org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
      4. org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463)
      5. org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398)
      6. org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
      6 frames
    11. struts
      ActionServlet.doPost
      1. org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)
      2. org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)
      3. org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)
      4. org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)
      5. org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)
      6. org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
      7. org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
      7 frames
    12. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      2 frames
    13. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      7. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526)
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      9 frames
    14. Grizzly HTTP
      LeaderFollowerWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
      4 frames
    15. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      1 frame
    16. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame