java.sql.SQLException: ORA-00900: Ungültige SQL-Anweisung

Oracle Community | 666705 | 1 decade ago
  1. 0

    update query in jdo

    Oracle Community | 1 decade ago | 666705
    java.sql.SQLException: ORA-00900: Ungültige SQL-Anweisung
  2. 0

    Error on weblogic server

    Oracle Community | 7 years ago | 617986
    javax.ejb.EJBException: EJB Exception: : Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.2.0.v20091016-r5565): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLException: Закрытая команда: getMetaData Error Code: 17009 Call: select tx.id_text_layers, tx.id from orbis_view_text_n tx where 1=1 and tx.zoom >7795 AND TX.ID_TEXT_LAYERS IN (10) and SDO_FILTER(tx.geoloc, sdo_geometry(2003, null, null, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(-4314914,5992546,3613301, 11200066)))='TRUE' order by tx.id_text_layers, tx.id Query: ReadAllQuery(name="GetTextsID" referenceClass=MpTextsid sql="select tx.id_text_layers, tx.id from orbis_view_text_n tx where 1=1 and tx.zoom >7795 AND TX.ID_TEXT_LAYERS IN (10) and SDO_FILTER(tx.geoloc, sdo_geometry(2003, null, null, SDO_ELEM_INFO_ARRAY(1, 1003, 3), SDO_ORDINATE_ARRAY(-4314914,5992546,3613301, 11200066)))='TRUE' order by tx.id_text_layers, tx.id ")
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    java.sql.SQLException: Closed Statement

    Oracle Community | 5 years ago | 867821
    java.sql.SQLException: Closed Statement: getMetaData
  5. 0

    stored procedure in ODISqlUnload

    Oracle Community | 6 years ago | 789352
    java.sql.SQLException: ORA-00900: invalid SQL statement

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

      ORA-00900: Ungültige SQL-Anweisung

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleResultSetImpl.getMetaData
      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:283)
      4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
      5. oracle.jdbc.driver.T4C8Odscrarr.receive(T4C8Odscrarr.java:214)
      6. oracle.jdbc.driver.T4CCallableStatement.doDescribe(T4CCallableStatement.java:731)
      7. oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:3458)
      8. oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaData.java:57)
      9. oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:138)
      9 frames
    3. com.solarmetric.jdbc
      DelegatingResultSet.getMetaData
      1. com.solarmetric.jdbc.DelegatingResultSet.getMetaData(DelegatingResultSet.java:363)
      1 frame
    4. kodo.jdbc.kernel
      SQLStoreQuery$SQLExecutor.executeQuery
      1. kodo.jdbc.kernel.SQLProjectionResultObjectProvider.<init>(SQLProjectionResultObjectProvider.java:43)
      2. kodo.jdbc.kernel.SQLStoreQuery$SQLExecutor.executeQuery(SQLStoreQuery.java:245)
      2 frames
    5. kodo.kernel
      DelegatingQuery.updateAll
      1. kodo.kernel.QueryImpl.execute(QueryImpl.java:1132)
      2. kodo.kernel.QueryImpl.updateInMemory(QueryImpl.java:1263)
      3. kodo.kernel.AbstractStoreQuery$AbstractExecutor.executeUpdate(AbstractStoreQuery.java:157)
      4. kodo.kernel.AbstractStoreQuery$AbstractExecutor.executeUpdate(AbstractStoreQuery.java:163)
      5. kodo.kernel.QueryImpl.update(QueryImpl.java:1240)
      6. kodo.kernel.QueryImpl.execute(QueryImpl.java:957)
      7. kodo.kernel.QueryImpl.updateAll(QueryImpl.java:1012)
      8. kodo.kernel.DelegatingQuery.updateAll(DelegatingQuery.java:865)
      8 frames
    6. kodo.jdo
      QueryImpl.updatePersistentAll
      1. kodo.jdo.QueryImpl.updatePersistentAll(QueryImpl.java:815)
      1 frame
    7. com.ottogroup.buying
      ChangeTrackingExportEntryRepositoryImpl.updateConfirmedStateToExportedByConfirmedStateAndExportId
      1. com.ottogroup.buying.infrastructure.dao.masterdatachange.jdo.ChangeTrackingExportEntryRepositoryDaoJdoImpl.updateConfirmedStateToExportedByConfirmedStateAndExportId(ChangeTrackingExportEntryRepositoryDaoJdoImpl.java:133)
      2. com.ottogroup.buying.sharedkernel.object.masterdatachange.changeexport.ChangeTrackingExportEntryRepositoryImpl.updateConfirmedStateToExportedByConfirmedStateAndExportId(ChangeTrackingExportEntryRepositoryImpl.java:78)
      2 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    9. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
      3 frames
    10. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
      1 frame
    11. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
      2 frames
    12. Unknown
      $Proxy161.updateConfirmedStateToExportedByConfirmedStateAndExportId
      1. $Proxy161.updateConfirmedStateToExportedByConfirmedStateAndExportId(Unknown Source)
      1 frame
    13. com.ottogroup.buying
      ChangeExportServiceImpl.export
      1. com.ottogroup.buying.sharedkernel.service.changeexport.ChangeExportServiceImpl.export(ChangeExportServiceImpl.java:177)
      1 frame
    14. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    15. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:287)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
      3 frames
    16. com.ottogroup.buying
      AopMessageHandler.invoke
      1. com.ottogroup.buying.sharedkernel.object.base.error.AopMessageHandler.invoke(AopMessageHandler.java:38)
      1 frame
    17. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
      1 frame
    18. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
      1 frame
    19. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
      2 frames
    20. Unknown
      $Proxy168.export
      1. $Proxy168.export(Unknown Source)
      1 frame
    21. test.ottogroup.sharedkernel
      ChangeExportTest.testAll
      1. test.ottogroup.sharedkernel.object.persistence.base.ChangeExportTest.export(ChangeExportTest.java:146)
      2. test.ottogroup.sharedkernel.object.persistence.base.ChangeExportTest.testAll(ChangeExportTest.java:158)
      2 frames
    22. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      4. java.lang.reflect.Method.invoke(Unknown Source)
      4 frames
    23. JUnit
      TestSuite.run
      1. junit.framework.TestCase.runTest(TestCase.java:154)
      2. junit.framework.TestCase.runBare(TestCase.java:127)
      3. junit.framework.TestResult$1.protect(TestResult.java:106)
      4. junit.framework.TestResult.runProtected(TestResult.java:124)
      5. junit.framework.TestResult.run(TestResult.java:109)
      6. junit.framework.TestCase.run(TestCase.java:118)
      7. junit.framework.TestSuite.runTest(TestSuite.java:208)
      8. junit.framework.TestSuite.run(TestSuite.java:203)
      8 frames
    24. JUnit3 Runner
      RemoteTestRunner.main
      1. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:478)
      2. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:344)
      3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
      3 frames