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

    Datetime field overflow in DB2 with Kodo 3.0.3

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008 {prepstmnt 17678065 INSERT INTO COR.T_PROJECTCOST (AMOUNT_F, APPROVALINFO_VC, BILLABLE_B, DATE_DT, DESCRIPTION_VC, ID_I, NAME_VC, PROJECTCOSTTYPE_ID_I, PROJECT_ID_I, ROWVERSION_I) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [reused=0]} [code=-99999, state=22008]
  3. 0

    Update failed when trying to update a nested object

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for identity column in table 'SessionType' when IDENTITY_INSERT is set to OFF.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    XA error

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ORA-02019: can't find the connection description {prepstmnt 10 INSERT INTO QUAKEGAO@TEST (JDOCLASS, JDOVERSION, NAME0, OID, PWD) VALUES (?, ?, ?, ?, ?)} [code=2019, state=]
  6. 0

    oracle clob problem

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ORA-00600: internal error code, arguments: [kokleva], [], [], [], [], [], [], [] {prepstmnt 1173845 INSERT INTO EPSCHEDULE.SC_TMEMO (CONTENT, JDOVERSION, MCODE, MODIFYTIME, RCODE, RFLAG, TITLE, USERID, USERNAME, WDATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=600, state=60000]

    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. com.solarmetric.jdbc.ReportingSQLException

      Missing IN or OUT parameter at index:: 2 {prepstmnt 31469867 DELETE FROM CATADMIN.PLATE_DATASETLISTX WHERE DATASETLISTX = ? AND JDOIDX = ? [params=(long) 9147124] [reused=1]} [code=17041, state=null]

      at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap()
    2. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeUpdate
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:67)
      2. com.solarmetric.jdbc.LoggingConnectionDecorator.access$400(LoggingConnectionDecorator.java:19)
      3. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:649)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
      4 frames
    3. 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
    4. kodo.jdbc.meta
      ManyToManyFieldMapping.update
      1. kodo.jdbc.meta.ManyToManyFieldMapping.update(ManyToManyFieldMapping.java:447)
      1 frame
    5. 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
    6. 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
    7. 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
    8. com.bd.mpm
      MPMSession.saveObject
      1. com.bd.mpm.datamodel.session.MPMSession.saveObject(MPMSession.java:322)
      1 frame
    9. com.bd.framework
      DefaultAppItem.save
      1. com.bd.framework.common.DefaultAppItem.save(DefaultAppItem.java:286)
      1 frame
    10. 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
    11. 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
    12. 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