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]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 3004, 1 year ago
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]
via Oracle Community by 3004, 4 months ago
Cannot insert duplicate key row in object 'CHILDREN' with unique index 'CHILD_UNQ'. {prepstmnt 1447297 UPDATE CHILDREN SET CHILDPOSITION = ? WHERE CHILDID = ? [params=(int) 0, (int) 103] [reused=0]} [code=2601, state=23000]
via Oracle Community by 3004, 1 year ago
[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]
via Oracle Community by 3004, 1 year ago
ORA-01407: cannot update ("CS2"."OBLIGATION"."CONTRACT_ID") to NULL {prepstmnt 12985263 UPDATE CS2.OBLIGATION SET CONTRACT_ID = ?, MODIFICATION_ID = ? WHERE CONTRACT_ID = ? AND MODIFICATION_ID = ? [params=(null) null, (null) null, (long) 130, (int) 2]} [code=1407, state=72000]
via Oracle Community by 3004, 4 months ago
, t0.MAXRECHARGE, t0.MAXROWS, t0.MAXSTRIKE, t0.MAXTRANSFER, t0.MINDRAW, t0.MINRECHARGE, t0.MINSTRIKE, t0.MINTRANSFER, t0.GROUPID, t0.RECHARGEABLE, t0.USERTYPEMODIFICATION FROM OLTP.GROUPSETTING t0 INNER JOIN OLTP.ORGANGROUP t1 ON t0.GROUPID = t1.GROUPID WHERE (t1.GROUPID = ?) FOR UPDATE [reused=0]} [code=-511, state=42829]
via Oracle Community by 3004, 4 months ago
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for identity column in table 'SessionType' when IDENTITY_INSERT is set to OFF. {prepstmnt 13784376 INSERT INTO dbo.SessionType (description, SessionTypeId) VALUES (?, ?) [params_(null) null, (int) 2]} [code_544, state_23000]
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(LoggingConnectionDecorator.java:67)
at com.solarmetric.jdbc.LoggingConnectionDecorator.access$400(LoggingConnectionDecorator.java:19)
at com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:649)
at com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:361)
at kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager.java:164)
at kodo.jdbc.runtime.PreparedStatementManager.flush(PreparedStatementManager.java:128)
at kodo.jdbc.runtime.NoFKOrBatchRowManager.flushSecondaryRow(NoFKOrBatchRowManager.java:51)
at kodo.jdbc.meta.ManyToManyFieldMapping.update(ManyToManyFieldMapping.java:447)
at kodo.jdbc.runtime.UpdateManagerImpl.update(UpdateManagerImpl.java:303)
at kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:126)
at kodo.jdbc.runtime.UpdateManagerImpl.flush(UpdateManagerImpl.java:72)
at kodo.jdbc.runtime.JDBCStoreManager.flush(JDBCStoreManager.java:507)
at kodo.runtime.PersistenceManagerImpl.flushInternal(PersistenceManagerImpl.java:794)
at kodo.runtime.PersistenceManagerImpl.beforeCompletion(PersistenceManagerImpl.java:650)
at kodo.runtime.LocalManagedRuntime.commit(LocalManagedRuntime.java:69)
at kodo.runtime.PersistenceManagerImpl.commit(PersistenceManagerImpl.java:422)
at com.bd.jdo.PersistenceHelper.commit(PersistenceHelper.java:302)
at com.bd.jdo.PersistenceHelper.commit(PersistenceHelper.java:295)
at com.bd.mpm.datamodel.session.MPMSession.saveObject(MPMSession.java:322)
at com.bd.framework.common.DefaultAppItem.save(DefaultAppItem.java:286)
at com.bd.navigator.model.NavFile.save(NavFile.java:170)
at com.bd.navigator.model.FileSystem.saveFile(FileSystem.java:615)
at com.bd.navigator.NavigatorHelper.save(NavigatorHelper.java:136)
at com.bd.navigator.Navigator.save(Navigator.java:172)
at com.bd.mpm.plate.ui.protocolEditor.ProtocolEditorController.saveWIM(ProtocolEditorController.java:604)
at com.bd.mpm.plate.ui.protocolEditor.ProtocolEditorController$SaveWIMAdapter.actionPerformed(ProtocolEditorController.java:2148)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)
at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
at javax.swing.AbstractButton.doClick(AbstractButton.java:289)
at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)
at javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943)
at java.awt.Component.processMouseEvent(Component.java:5100)
at java.awt.Component.processEvent(Component.java:4897)
at java.awt.Container.processEvent(Container.java:1569)
at java.awt.Component.dispatchEventImpl(Component.java:3615)
at java.awt.Container.dispatchEventImpl(Container.java:1627)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)
at java.awt.Container.dispatchEventImpl(Container.java:1613)
at java.awt.Window.dispatchEventImpl(Window.java:1606)
at java.awt.Component.dispatchEvent(Component.java:3477)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:456)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.