java.sql.SQLException

ORA-22905: cannot access rows from a non-nested table ite m at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java

Samebug tips1

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

Don't give up yet. Our experts can help. Paste your full stack trace to get a solution.

Solutions on the web12986

  • via Oracle Community by user737831, 11 months ago
    ORA-22905: cannot access rows from a non-nested table ite m at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
  • via Oracle Community by W. van Riel, 11 months ago
    ORA-22905: cannot access rows from a non-nested table item
  • via Oracle Community by Karthic Rajha, 11 months ago
    ORA-01779: cannot modify a column which maps to a non key-preserved table ORA-06512: at line 1at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
  • Stack trace

    • java.sql.SQLException: ORA-22905: cannot access rows from a non-nested table ite m at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:789) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:829) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1131) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1271) at oracle.spatial.network.GeometryMetadata.<init>(GeometryMetadata.java:112) at oracle.spatial.network.NetworkMetadataImpl.<init>(NetworkMetadataImpl.java:322) at oracle.spatial.network.NetworkAdapterSDO.readNetworkMetadata(NetworkAdapterSDO.java:6445) at oracle.spatial.network.NetworkManager.readNetworkMetadata(NetworkManager.java:318) at oracle.spatial.network.NetworkPartition.getNoOfPartitions(NetworkPartition.java:882) at oracle.spatial.network.NetworkManager.isNetworkPartitioned(NetworkManager.java:2202) at oracle.spatial.network.editor.FileMenu$12.actionPerformed(FileMenu.java:851) at javax.swing.JComboBox.fireActionEvent(Unknown Source) at javax.swing.JComboBox.setSelectedItem(Unknown Source) at javax.swing.JComboBox.setSelectedIndex(Unknown Source) at javax.swing.plaf.basic.BasicComboPopup$Handler.mouseReleased(UnknownSource) at java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at javax.swing.plaf.basic.BasicComboPopup$1.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.Dialog$1.run(Unknown Source) at java.awt.Dialog$3.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Unknown Source) at oracle.spatial.network.editor.FileMenu.createAndShowReadFromDatabaseDialog(FileMenu.java:998) at oracle.spatial.network.editor.FileMenu.access$200(FileMenu.java:54) at oracle.spatial.network.editor.FileMenu$3.actionPerformed(FileMenu.java:157) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.AbstractButton.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(UnknownSource) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 2 months ago
    Once, 3 months ago
    10 times, 3 months ago
    6 times, 6 months ago
    46 more bugmates