org.apache.jasper.JasperException: javax.servlet.jsp.JspException: Error getting property 'lastItem' from bean of type br.com.sequor.wsqo.domain.WsqosequenciamentoestacaoController: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368) com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322) com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130) com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87) com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200) com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117) javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)[/i] and other: [i]caused by: java.sql.SQLException: ORA-00907: parêntese direito não encontrado

Oracle Community | eliasn | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    JPA Query error....

    Oracle Community | 1 decade ago | eliasn
    org.apache.jasper.JasperException: javax.servlet.jsp.JspException: Error getting property 'lastItem' from bean of type br.com.sequor.wsqo.domain.WsqosequenciamentoestacaoController: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368) com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322) com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130) com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87) com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200) com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117) javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)[/i] and other: [i]caused by: java.sql.SQLException: ORA-00907: parêntese direito não encontrado

    Root Cause Analysis

    1. org.apache.jasper.JasperException

      javax.servlet.jsp.JspException: Error getting property 'lastItem' from bean of type br.com.sequor.wsqo.domain.WsqosequenciamentoestacaoController: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264) javax.servlet.http.HttpServlet.service(HttpServlet.java:802) org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368) com.sun.faces.context.ExternalContextImpl.dispatch(ExternalContextImpl.java:322) com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:130) com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87) com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200) com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:117) javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:368)[/i] and other: [i]caused by: java.sql.SQLException: ORA-00907: parêntese direito não encontrado

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      6. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
      7. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
      8. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
      10. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
      11. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
      11 frames
    3. Hibernate
      Loader.doList
      1. org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
      3. org.hibernate.loader.Loader.doQuery(Loader.java:662)
      4. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      5. org.hibernate.loader.Loader.doList(Loader.java:2145)
      5 frames