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

Oracle Community | 3004 | 1 decade ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  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

    Invalid character encountered in: failAL32UTF8Conv

    Oracle Community | 1 decade ago | 843859
    java.sql.SQLException: Io exception: Invalid character encountered in: failAL32UTF8Conv
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JMS dealock sending object message

    Google Groups | 1 decade ago | Derekjb
    java.sql.SQLException: Io exception: Connection timed out: Connection timed out
  6. 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))

  1. rp 1 times, last 4 months ago
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