oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO AM_AMORT_PROFILES(APR_GRP_ID,APR_CMP_ID,APR_CODE,APR_ID,APR_IFA_CODE,APR_DESCRIPTION_LOC,APR_DESCRIPTION_ETR,APR_DEV_ID,APR_DEVISE_TAUX,APR_VALEUR_ACQUIS,APR_VALEUR_ACQUIS_LC,APR_VALEUR_RESIDUELLE,APR_VALEUR_RESIDUELLE_LC,APR_DATE_ACQUIS,APR_DATE_SERVICE,APR_QUANTITE,APR_FOURNISSEUR_CODE,APR_FOURNISSEUR_LOC,APR_BAT_ID,APR_BUR_ID,APR_ETA_ID,APR_TYPE,APR_AMORT_MODE,APR_AMORT_DUREE_AN,APR_AMORT_DUREE_MOIS,APR_AMORT_DATE_DEPART,APR_AMORT_PRORATA,APR_VALEUR_AMORT_JOURS,APR_VALEUR_AMORT_JOURS_LC,APR_COMPTE_IMO,APR_COMPTE_ECO,APR_COMPTE_DOT,APR_COMPTE_VCT,APR_COMPTE_CCS,APR_COMPTE_PCS,APR_COMPTE_TVA,APR_ACTIVE_FLAG,APR_VALIDE_FLAG,APR_CREER_PAR,APR_CREER_DATE,APR_VALEUR_AMORT_MOIS,APR_VALEUR_AMORT_MOIS_LC,APR_STATU) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43)".

Oracle Community | frsofiane | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    oracle.jbo.DMLException: JBO-26041: Failed to post data to database during

    Oracle Community | 5 years ago | frsofiane
    oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO AM_AMORT_PROFILES(APR_GRP_ID,APR_CMP_ID,APR_CODE,APR_ID,APR_IFA_CODE,APR_DESCRIPTION_LOC,APR_DESCRIPTION_ETR,APR_DEV_ID,APR_DEVISE_TAUX,APR_VALEUR_ACQUIS,APR_VALEUR_ACQUIS_LC,APR_VALEUR_RESIDUELLE,APR_VALEUR_RESIDUELLE_LC,APR_DATE_ACQUIS,APR_DATE_SERVICE,APR_QUANTITE,APR_FOURNISSEUR_CODE,APR_FOURNISSEUR_LOC,APR_BAT_ID,APR_BUR_ID,APR_ETA_ID,APR_TYPE,APR_AMORT_MODE,APR_AMORT_DUREE_AN,APR_AMORT_DUREE_MOIS,APR_AMORT_DATE_DEPART,APR_AMORT_PRORATA,APR_VALEUR_AMORT_JOURS,APR_VALEUR_AMORT_JOURS_LC,APR_COMPTE_IMO,APR_COMPTE_ECO,APR_COMPTE_DOT,APR_COMPTE_VCT,APR_COMPTE_CCS,APR_COMPTE_PCS,APR_COMPTE_TVA,APR_ACTIVE_FLAG,APR_VALIDE_FLAG,APR_CREER_PAR,APR_CREER_DATE,APR_VALEUR_AMORT_MOIS,APR_VALEUR_AMORT_MOIS_LC,APR_STATU) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25,:26,:27,:28,:29,:30,:31,:32,:33,:34,:35,:36,:37,:38,:39,:40,:41,:42,:43)".
  2. 0

    (java.sql.SQLException) Invalid column type | Oracle Community

    oracle.com | 1 year ago
    oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO ENTRY(ENTRY_ID,ENTRY_CLASS_ID,NOTES,ACTIVE,INTERFACE,TOTAL_DEBIT,TOTAL_CREDIT,CREATED_ON,CREATED_BY) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9)".
  3. 0

    (java.sql.SQLException) Invalid column type

    Oracle Community | 6 years ago | luisvil
    oracle.jbo.DMLException: JBO-26041: Failed to post data to database during "Insert": SQL Statement "INSERT INTO ENTRY(ENTRY_ID,ENTRY_CLASS_ID,NOTES,ACTIVE,INTERFACE,TOTAL_DEBIT,TOTAL_CREDIT,CREATED_ON,CREATED_BY) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9)".
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Calling PL/SQL procedure with SYS_REFCURSOR as IN parameter using JDBC

    Stack Overflow | 2 years ago | Twister
    java.sql.SQLException: Invalid column type
  6. 0

    Using Types.NVARCHAR with oracle JDBC driver to work with Cyrillic chars

    Stack Overflow | 6 years ago | Leo Holanda
    java.sql.SQLException: Invalid column type

    8 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

      Invalid column type

      at oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical()
    2. Oracle jdbc
      OraclePreparedStatementWrapper.setObject
      1. oracle.jdbc.driver.OraclePreparedStatement.setObjectCritical(OraclePreparedStatement.java:11169)
      2. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:10518)
      3. oracle.jdbc.driver.OraclePreparedStatement.setObjectInternal(OraclePreparedStatement.java:11574)
      4. oracle.jdbc.driver.OraclePreparedStatement.setObject(OraclePreparedStatement.java:11544)
      5. oracle.jdbc.driver.OraclePreparedStatementWrapper.setObject(OraclePreparedStatementWrapper.java:249)
      5 frames
    3. oracle.jbo.server
      EntityImpl.doDML
      1. oracle.jbo.server.OracleSQLBuilderImpl.bindInsertStatement(OracleSQLBuilderImpl.java:2033)
      2. oracle.jbo.server.EntityImpl.bindDMLStatement(EntityImpl.java:10424)
      3. oracle.jbo.server.OracleSQLBuilderImpl.doEntityDML(OracleSQLBuilderImpl.java:415)
      4. oracle.jbo.server.EntityImpl.doDML(EntityImpl.java:8494)
      4 frames
    4. Immoblisation.model
      AmAmortProfilesImpl.doDML
      1. Immoblisation.model.AmAmortProfilesImpl.doDML(AmAmortProfilesImpl.java:1699)
      1 frame
    5. oracle.jbo.server
      DBTransactionImpl.commit
      1. oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:6751)
      2. oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3264)
      3. oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:3067)
      4. oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2071)
      5. oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2352)
      5 frames
    6. oracle.adf.model
      DCDataControl.callCommitTransaction
      1. oracle.adf.model.bc4j.DCJboDataControl.commitTransaction(DCJboDataControl.java:1590)
      2. oracle.adf.model.binding.DCDataControl.callCommitTransaction(DCDataControl.java:1415)
      2 frames
    7. oracle.jbo.uicli
      JUCtrlActionBinding.doIt
      1. oracle.jbo.uicli.binding.JUCtrlActionBinding.doIt(JUCtrlActionBinding.java:1428)
      1 frame
    8. oracle.adf.model
      DCDataControl.invokeOperation
      1. oracle.adf.model.binding.DCDataControl.invokeOperation(DCDataControl.java:2169)
      1 frame
    9. oracle.jbo.uicli
      JUNavigationBar.doAction
      1. oracle.jbo.uicli.binding.JUCtrlActionBinding.invoke(JUCtrlActionBinding.java:731)
      2. oracle.jbo.uicli.jui.JUActionBinding.actionPerformed(JUActionBinding.java:193)
      3. oracle.jbo.uicli.controls.JUNavigationBar.doAction(JUNavigationBar.java:412)
      3 frames
    10. oracle.jbo.jbotester
      NavigationBar.doAction
      1. oracle.jbo.jbotester.NavigationBar.doAction(NavigationBar.java:112)
      1 frame
    11. oracle.jbo.uicli
      JUNavigationBar$NavButton.actionPerformed
      1. oracle.jbo.uicli.controls.JUNavigationBar$NavButton.actionPerformed(JUNavigationBar.java:118)
      1 frame
    12. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
      2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      6. java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      7. java.awt.Component.processMouseEvent(Component.java:6289)
      8. javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      9. java.awt.Component.processEvent(Component.java:6054)
      10. java.awt.Container.processEvent(Container.java:2041)
      11. java.awt.Component.dispatchEventImpl(Component.java:4652)
      12. java.awt.Container.dispatchEventImpl(Container.java:2099)
      13. java.awt.Component.dispatchEvent(Component.java:4482)
      14. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
      15. java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
      16. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
      17. java.awt.Container.dispatchEventImpl(Container.java:2085)
      18. java.awt.Window.dispatchEventImpl(Window.java:2478)
      19. java.awt.Component.dispatchEvent(Component.java:4482)
      20. java.awt.EventQueue.dispatchEventImpl(EventQueue.java:644)
      21. java.awt.EventQueue.access$000(EventQueue.java:85)
      22. java.awt.EventQueue$1.run(EventQueue.java:603)
      23. java.awt.EventQueue$1.run(EventQueue.java:601)
      24. java.security.AccessController.doPrivileged(Native Method)
      25. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      26. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
      27. java.awt.EventQueue$2.run(EventQueue.java:617)
      28. java.awt.EventQueue$2.run(EventQueue.java:615)
      29. java.security.AccessController.doPrivileged(Native Method)
      30. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      31. java.awt.EventQueue.dispatchEvent(EventQueue.java:614)
      32. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
      33. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
      34. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
      35. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
      36. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
      37. java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      37 frames