oracle.spatial.network.lod.LODNetworkException: oracle.spatial.network.lod.LODNetworkException: oracle.jdbc.driver.OracleSQLException: ORA-00923: FROM keyword not found where expected

Oracle Community | 7796 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    find_connected_components produces ORA-00923: FROM keyword not found where

    Oracle Community | 6 years ago | 7796
    oracle.spatial.network.lod.LODNetworkException: oracle.jdbc.driver.OracleSQLException: ORA-00923: FROM keyword not found where expected

    Root Cause Analysis

    1. oracle.jdbc.driver.OracleSQLException

      ORA-00923: FROM keyword not found where expected

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java)
      2. oracle.jdbc.driver.T2SConnection.check_error(T2SConnection.java)
      3. oracle.jdbc.driver.T2SPreparedStatement.checkError(T2SPreparedStatement.java:103)
      4. oracle.jdbc.driver.T2SPreparedStatement.describe_internal(T2SPreparedStatement.java)
      5. oracle.jdbc.driver.T2SPreparedStatement.executeForDescribe(T2SPreparedStatement.java)
      6. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
      8. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java)
      9. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
      10. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java)
      10 frames
    3. oracle.spatial.network
      LODNetworkWrapper.findConnectedComponents
      1. oracle.spatial.network.lod.LODNetworkAdaptorSDO.addLinksAndExternalNodes(LODNetworkAdaptorSDO.java:2799)
      2. oracle.spatial.network.lod.LODNetworkAdaptorSDO.readLogicalPartition(LODNetworkAdaptorSDO.java:2662)
      3. oracle.spatial.network.lod.NetworkIOImpl.readLogicalPartition(NetworkIOImpl.java:325)
      4. oracle.spatial.network.lod.CachedNetworkIOImpl.readLogicalPartition(CachedNetworkIOImpl.java:106)
      5. oracle.spatial.network.lod.CachedNetworkIOImpl.readLogicalPartition(CachedNetworkIOImpl.java:95)
      6. oracle.spatial.network.lod.NetworkExplorer.getPartition(NetworkExplorer.java:208)
      7. oracle.spatial.network.lod.BreadthFirstSearch.findConnectedComponentsStartFromPartition(BreadthFirstSearch.java:135)
      8. oracle.spatial.network.lod.BreadthFirstSearch.findConnectedComponents(BreadthFirstSearch.java:102)
      9. oracle.spatial.network.lod.NetworkAnalyst.findConnectedComponents(NetworkAnalyst.java:1605)
      10. oracle.spatial.network.lod.LODNetworkWrapper.findConnectedComponents(LODNetworkWrapper.java:239)
      10 frames