java.sql.SQLException: ORA-00900: invalid SQL statement

Oracle Community | oimuser007 | 6 years ago
  1. 0

    SQL in OIM Schedular throwing error in logs

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

    stored procedure in ODISqlUnload

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

    DBProvider Error

    Oracle Community | 7 years ago | user4884609
    java.sql.SQLException: ORA-00900: invalid SQL statement
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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 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: invalid SQL statement

      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.T4CStatement.doDescribe(T4CStatement.java:734)
      7. oracle.jdbc.driver.OracleStatement.describe(OracleStatement.java:3462)
      8. oracle.jdbc.driver.OracleResultSetMetaData.<init>(OracleResultSetMetaData.java:57)
      9. oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:138)
      9 frames
    3. JBoss Application Server Connector
      WrappedResultSet.getMetaData
      1. org.jboss.resource.adapter.jdbc.WrappedResultSet.getMetaData(WrappedResultSet.java:737)
      1 frame
    4. com.thortech.xl
      tcDataBaseBean.readEncryptedStatement
      1. com.thortech.xl.cache.MetaDataColumnCache.loadColumns(Unknown Source)
      2. com.thortech.xl.dataaccess.tcDataBase.loadResultSet(Unknown Source)
      3. com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
      4. com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
      5. com.thortech.xl.dataobj.tcDataBase.readEncryptedStatement(Unknown Source)
      6. com.thortech.xl.ejb.databeansimpl.tcDataBaseBean.readEncryptedStatement(Unknown Source)
      6 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor142.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    6. JBoss Application Server Server
      SecurityInterceptor.invoke
      1. org.jboss.invocation.Invocation.performCall(Invocation.java:359)
      2. org.jboss.ejb.StatefulSessionContainer$ContainerInterceptor.invoke(StatefulSessionContainer.java:598)
      3. org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
      3 frames
    7. JBoss Application Server Connector
      CachedConnectionInterceptor.invoke
      1. org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
      1 frame
    8. JBoss Application Server Server
      TxInterceptorCMT.runWithTransactions
      1. org.jboss.ejb.plugins.StatefulSessionInstanceInterceptor.invoke(StatefulSessionInstanceInterceptor.java:333)
      2. org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
      3. org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
      4. org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
      4 frames