java.sql.SQLException: Missing IN or OUT parameter at index:: 2

Oracle Community | 3004 | 1 decade ago
  1. 0

    Missing IN or OUT parameter in SQL statement

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: Missing IN or OUT parameter at index:: 2
  2. 0

    Passing elements of array to an Oracle database table using for loop

    Stack Overflow | 4 years ago | Mavrick
    java.sql.SQLException: Missing IN or OUT parameter at index:: 1
  3. 0

    JMS dealock sending object message

    Google Groups | 1 decade ago | Derekjb
    java.sql.SQLException: Io exception: Connection timed out: Connection timed out
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Stale Connection issue with WAS 4.0.2

    Google Groups | 1 decade ago | Praneeta Rao
    java.sql.SQLException: Io exception: A connection with a remote socket was reset by that socket.: A connection with a remote socket was reset by that socket. at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java(CompiledCode))
  6. 0

    JMS and EJB cause problem?

    Google Groups | 1 decade ago | Okros Peter
    java.sql.SQLException: Io exception: Connection reset)

    26 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

      Missing IN or OUT parameter at index:: 2

      at oracle.jdbc.dbaccess.DBError.throwSqlException()
    2. oracle.jdbc.dbaccess
      DBError.throwSqlException
      1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      2. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
      2 frames
    3. Oracle jdbc
      OraclePreparedStatement.executeUpdate
      1. oracle.jdbc.driver.OracleStatement.checkBindsInAndOut(OracleStatement.java:1876)
      2. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2638)
      3. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
      3 frames
    4. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeUpdate
      1. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      2. com.solarmetric.jdbc.PoolConnection$PoolPreparedStatement.executeUpdate(PoolConnection.java:374)
      3. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      5. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      6. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:645)
      7. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      7 frames
    5. kodo.jdbc.runtime
      NoFKOrBatchRowManager.flushSecondaryRow
      1. kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager.java:164)
      2. kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager.java:128)
      3. kodo.jdbc.runtime.NoFKOrBatchRowManager.flushSecondaryRow(NoFKOrBatchRowManager.java:51)
      3 frames
    6. kodo.jdbc.meta
      ManyToManyFieldMapping.update
      1. kodo.jdbc.meta.ManyToManyFieldMapping.update(ManyToManyFieldMapping.java:447)
      1 frame
    7. kodo.jdbc.runtime
      JDBCStoreManager.flush
      1. kodo.jdbc.runtime.UpdateManagerImpl.update(UpdateManagerImpl.java:303)
      2. kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:126)
      3. kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:72)
      4. kodo.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:507)
      4 frames
    8. kodo.runtime
      PersistenceManagerImpl.commit
      1. kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:794)
      2. kodo.runtime.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:650)
      3. kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:69)
      4. kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:422)
      4 frames
    9. com.bd.jdo
      PersistenceHelper.commit
      1. com.bd.jdo.PersistenceHelper.commit(PersistenceHelper.java:302)
      2. com.bd.jdo.PersistenceHelper.commit(PersistenceHelper.java:295)
      2 frames
    10. com.bd.mpm
      MPMSession.saveObject
      1. com.bd.mpm.datamodel.session.MPMSession.saveObject(MPMSession.java:322)
      1 frame
    11. com.bd.framework
      DefaultAppItem.save
      1. com.bd.framework.common.DefaultAppItem.save(DefaultAppItem.java:286)
      1 frame
    12. com.bd.navigator
      Navigator.save
      1. com.bd.navigator.model.NavFile.save(NavFile.java:170)
      2. com.bd.navigator.model.FileSystem.saveFile(FileSystem.java:615)
      3. com.bd.navigator.NavigatorHelper.save(NavigatorHelper.java:136)
      4. com.bd.navigator.Navigator.save(Navigator.java:172)
      4 frames
    13. com.bd.mpm
      ProtocolEditorController$SaveWIMAdapter.actionPerformed
      1. com.bd.mpm.plate.ui.protocolEditor.ProtocolEditorController.saveWIM(ProtocolEditorController.java:604)
      2. com.bd.mpm.plate.ui.protocolEditor.ProtocolEditorController$SaveWIMAdapter.actionPerformed(ProtocolEditorController.java:2148)
      2 frames
    14. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
      2. javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
      5. javax.swing.AbstractButton.doClick(AbstractButton.java:289)
      6. javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
      7. javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943)
      8. java.awt.Component.processMouseEvent(Component.java:5100)
      9. java.awt.Component.processEvent(Component.java:4897)
      10. java.awt.Container.processEvent(Container.java:1569)
      11. java.awt.Component.dispatchEventImpl(Component.java:3615)
      12. java.awt.Container.dispatchEventImpl(Container.java:1627)
      13. java.awt.Component.dispatchEvent(Component.java:3477)
      14. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
      15. java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
      16. java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
      17. java.awt.Container.dispatchEventImpl(Container.java:1613)
      18. java.awt.Window.dispatchEventImpl(Window.java:1606)
      19. java.awt.Component.dispatchEvent(Component.java:3477)
      20. java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
      21. java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
      22. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
      23. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
      24. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
      25. java.awt.EventDispatchThread.run(EventDispatchThread.java:100)
      25 frames