oracle.jbo.DMLException

JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO MU_UREDJAJ(MUURE_ID) VALUES (:1)".

Solutions on the web179

  • via Oracle Community by newenrba, 11 months ago
    JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO MU_UREDJAJ(MUURE_ID) VALUES (:1)".
  • via Oracle Community by 407063, 8 months ago
    JBO-26041: Failed to post data to database during "Insert": SQL Statement "BEGIN INSERT INTO UNIDADE_DE_TREINAMENTOS(NUMERO,DESCRICAO,VALOR) VALUES (:1,:2,:3) RETURNING NUMERO INTO :4; END;".
  • via Oracle Community by 3004, 1 year ago
    JBO-26041: Failed to post data to database during "Insert": SQL Statement " INSERT INTO TEST.PERSON(AGE,NAME,ID) VALUES (:1,:2,:3)".
  • Stack trace

    • oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO MU_UREDJAJ(MUURE_ID) VALUES (:1)". at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:581) at oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:8518) at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:6775) at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3264) at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:3067) at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2071) at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2352) at oracle.adf.model.bc4j.DCJboDataControl.commitTransaction(DCJboDataControl.java:1590) at oracle.adf.model.binding.DCDataControl.callCommitTransaction(DCDataControl.java:1415) at oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1428) at oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2169) at oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:731) at oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193) at oracle.jbo.uicli.controls.JUNavigationBar.doAction(JUNavigationBar.java:412) at oracle.jbo.jbotester.NavigationBar.doAction(NavigationBar.java:112) at oracle.jbo.uicli.controls.JUNavigationBar$NavButton.actionPerformed(JUNavigationBar.java:118) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6289) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6054) at java.awt.Container.processEvent(Container.java:2041) at java.awt.Component.dispatchEventImpl(Component.java:4652) at java.awt.Container.dispatchEventImpl(Container.java:2099) at java.awt.Component.dispatchEvent(Component.java:4482) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168) at java.awt.Container.dispatchEventImpl(Container.java:2085) at java.awt.Window.dispatchEventImpl(Window.java:2478) at java.awt.Component.dispatchEvent(Component.java:4482) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:603) at java.awt.EventQueue$1.run(EventQueue.java:601) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:617) at java.awt.EventQueue$2.run(EventQueue.java:615) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:614) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: java.sql.SQLException: Invalid column type at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:11256) at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:10605) at oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:11665) at oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:11631) at oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:253) at oracle.jbo.server.OracleSQLBuilderImpl.bindInsertStatement(OracleSQLBuilderImpl.java:2036) at oracle.jbo.server.EntityImpl.bindDMLStatement(EntityImpl.java:10466) at oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:415) ... 52 more

    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, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    5 more bugmates