java.sql.SQLException: ORA-00907: Rechte Klammer fehlt

Oracle Community | 209828 | 1 decade ago
  1. 0

    JDBC Driver 10 throws ORA-00907 Exception

    Oracle Community | 1 decade ago | 209828
    java.sql.SQLException: ORA-00907: Rechte Klammer fehlt
  2. 0

    Extended length for varchar2 in Oracle 12c

    Stack Overflow | 2 years ago
    java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column Complete error stack (or at least the part that doesn't refer to my code) follows: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
  3. 0

    updateRow error:java.sql.SQLException: ORA-00907 missing right parenthesis

    Oracle Community | 1 decade ago | 843854
    java.sql.SQLException: ORA-00907: Rechte Klammer fehlt [java] [java]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problem searching non-string values within property bundles

    Oracle Community | 2 decades ago | 3004
    java.sql.SQLException: ORA-00907: missing right parenthesis
  6. 0

    I have the problem bellow. In short a have a Join entity and I am trying to do a order by and pagination. The error is in the position of the order by in the sql query (I am using Oracle 7.3). Please note that if the "order by" were outside the from select clause it works fine. Hibernate version: 3.03 Also using Spring, and WebWork Mapping documents: <hibernate-mapping schema="RCR" package="com.bcsinfo.tsheet.model"> <class name="com.bcsinfo.tsheet.model.TimeSheet" table="t_sheet"> <id name="Id" column="numero" type="java.lang.Long" length="12" > <generator class="native"> <param name="sequence">tsheet_numero_sq</param> </generator> </id> <many-to-one name="Professional" class="Professional" lazy="true"> <column name="COD_ADVG_REAL" not-null="true"/> </many-to-one> <many-to-one name="Matter" class="Matter" lazy="true"> <column name="pasta" not-null="true"/> <column name="cod_cliente" not-null="true"/> </many-to-one> <property name="Date" column="data" not-null="true"/> <join table="ativireal"> <key column="numero"/> <property name="IdAtiv" column="id_ativireal" not-null="true" unique="true"/> <many-to-one name="Activity" class="TSActivity" lazy="true"> <column name="codigo" not-null="true"/> </many-to-one> <component name="UT" class="UT"> <property name="UT" column="TEMPO_REAL" type="int" not-null="true" length="3"/> </component> <property name="CreationDate" column="DATA_INC" update="false" not-null="true"/> <property name="Description" column="COMPLEMENTO" not-null="true" length="2000"/> </join> </class> <query name="timesheet">from TimeSheet as t order by t.Date desc</query> </hibernate-mapping> Code between sessionFactory.openSession() and session.close(): I just set the maxResults and FirstResult properties. Full stack trace of any exception that occurs: <log4j:event logger="org.hibernate.SQL" timestamp="1115757046226" level="DEBUG" thread="http-8084-Processor22"> <log4j:message><![CDATA[select * from ( select timesheet0_.numero as numero, timesheet0_.COD_ADVG_REAL as COD2_12_, timesheet0_.pasta as pasta12_, timesheet0_.cod_cliente as cod4_12_, timesheet0_.data as data12_, timesheet0_1_.id_ativireal as id1_0_, timesheet0_1_.codigo as codigo0_, timesheet0_1_.TEMPO_REAL as TEMPO4_0_, timesheet0_1_.DATA_INC as DATA7_0_, timesheet0_1_.COMPLEMENTO as COMPLEME8_0_ from RCR.t_sheet timesheet0_, RCR.ativireal timesheet0_1_ where timesheet0_.numero=timesheet0_1_.numero order by timesheet0_.data desc ) where rownum <= ?]]></log4j:message> <log4j:locationInfo class="org.hibernate.jdbc.AbstractBatcher" method="log" file="AbstractBatcher.java" line="311"/> </log4j:event> <log4j:event logger="org.hibernate.util.JDBCExceptionReporter" timestamp="1115757046507" level="WARN" thread="http-8084-Processor22"> <log4j:message><![CDATA[SQL Error: 907, SQLState: 42000]]></log4j:message> <log4j:locationInfo class="org.hibernate.util.JDBCExceptionReporter" method="logExceptions" file="JDBCExceptionReporter.java" line="71"/> </log4j:event> <log4j:event logger="org.hibernate.util.JDBCExceptionReporter" timestamp="1115757046507" level="ERROR" thread="http-8084-Processor22"> <log4j:message><![CDATA[ORA-00907: missing right parenthesis ]]></log4j:message> <log4j:locationInfo class="org.hibernate.util.JDBCExceptionReporter" method="logExceptions" file="JDBCExceptionReporter.java" line="72"/> </log4j:event> <log4j:event logger="com.opensymphony.webwork.dispatcher.ServletDispatcher" timestamp="1115757046538" level="ERROR" thread="http-8084-Processor22"> <log4j:message><![CDATA[Could not execute action]]></log4j:message> <log4j:throwable><![CDATA[org.springframework.jdbc.BadSqlGrammarException: Bad SQL grammar [] in task 'Hibernate operation'; nested exception is java.sql.SQLException: ORA-00907: missing right parenthesis java.sql.SQLException: ORA-00907: missing right parenthesis at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:643) at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:314) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:118) at org.hibernate.loader.Loader.getResultSet(Loader.java:1239) at org.hibernate.loader.Loader.doQuery(Loader.java:374) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:210) at org.hibernate.loader.Loader.doList(Loader.java:1562) at org.hibernate.loader.Loader.list(Loader.java:1545) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271) at org.hibernate.impl.SessionImpl.list(SessionImpl.java:840) at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74) at com.bcsinfo.dao.hibernate.NamedQueryImpl$2.doInHibernate(NamedQueryImpl.java:232) at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:310) at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:291) at com.bcsinfo.dao.hibernate.NamedQueryImpl.getResultList(NamedQueryImpl.java:228) at com.bcsinfo.tsheet.wwactions.TSList.doIt(TSList.java:41) at com.bcsinfo.tsheet.wwactions.AbstractAction.execute(AbstractAction.java:54) at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:283) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:166) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:164) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:164) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:164) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:164) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:164) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:116) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:272) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:237) 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.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) 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.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:825) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526) 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:595) ]]></log4j:throwable> <log4j:locationInfo class="com.opensymphony.webwork.dispatcher.ServletDispatcher" method="serviceAction" file="ServletDispatcher.java" line="281"/> </log4j:event> Name and version of the database you are using: ORACLE 7.3 The generated SQL (show_sql=true): select * from ( select timesheet0_.numero as numero, timesheet0_.COD_ADVG_REAL as COD2_12_, timesheet0_.pasta as pasta12_, timesheet0_.cod_cliente as cod4_12_, timesheet0_.data as data12_, timesheet0_1_.id_ativireal as id1_0_, timesheet0_1_.codigo as codigo0_, timesheet0_1_.TEMPO_REAL as TEMPO4_0_, timesheet0_1_.DATA_INC as DATA7_0_, timesheet0_1_.COMPLEMENTO as COMPLEME8_0_ from RCR.t_sheet timesheet0_, RCR.ativireal timesheet0_1_ where timesheet0_.numero=timesheet0_1_.numero order by timesheet0_.data desc ) where rownum <= ?

    Hibernate JIRA | 1 decade ago | Luis Eduardo Villares Matta
    java.sql.SQLException: ORA-00907: missing right parenthesis

    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. java.sql.SQLException

      ORA-00907: Rechte Klammer fehlt

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      UpdatableResultSet.updateRow
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
      6. oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:543)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
      8. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
      9. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2960)
      10. oracle.jdbc.driver.UpdatableResultSet.execute_updateRow(UpdatableResultSet.java:2374)
      11. oracle.jdbc.driver.UpdatableResultSet.updateRow(UpdatableResultSet.java:1513)
      11 frames
    3. Commons DBCP
      DelegatingResultSet.updateRow
      1. org.apache.commons.dbcp.DelegatingResultSet.updateRow(DelegatingResultSet.java:487)
      2. org.apache.commons.dbcp.DelegatingResultSet.updateRow(DelegatingResultSet.java:487)
      2 frames
    4. elexir.dbvfs.dbaccess
      DirectDBAccessOracle9.writePreviewNode
      1. elexir.dbvfs.dbaccess.DirectDBAccessOracle9.writePreviewNode(DirectDBAccessOracle9.java:158)
      1 frame
    5. elexir.event.command
      AbstractCommand.runCommand
      1. elexir.event.command.dbvfs.GenerateAllPreviews.generatePreview4File(GenerateAllPreviews.java:130)
      2. elexir.event.command.dbvfs.GeneratePreview.execute(GeneratePreview.java:48)
      3. elexir.event.command.AbstractCommand.doExecute(AbstractCommand.java:366)
      4. elexir.event.command.BasicCommand.doExecute(BasicCommand.java:321)
      5. elexir.event.command.AbstractCommand.runCommand(AbstractCommand.java:346)
      5 frames
    6. elexir.event.core
      EventTools.sendRequestEvent
      1. elexir.event.core.EventTools.sendRequestEvent(EventTools.java:185)
      1 frame
    7. elexir.state
      CommandInterpreter.executeCommand
      1. elexir.state.CommandInterpreter.executeCommand(CommandInterpreter.java:230)
      1 frame
    8. elexir.servlet
      Servlet.doGet
      1. elexir.servlet.Servlet.doGet(Servlet.java:296)
      1 frame
    9. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2 frames
    10. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames
    11. elexir.util.servlet
      RequestLogger.doFilter
      1. elexir.util.servlet.filter.RequestLogger.doFilter(RequestLogger.java:87)
      1 frame
    12. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      4. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      5. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      6. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      7. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      8. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      9. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      10. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      11. org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
      12. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      13. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      14. org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      15. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      16. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
      17. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      18. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      19. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      20. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      21. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      22. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      23. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      23 frames
    13. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
      1 frame
    14. Grizzly HTTP
      TcpWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
      3. org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
      3 frames
    15. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
      1 frame
    16. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame