Uploaded image for project: 'Hibernate ORM'
  1. Hibernate ORM
  2. HHH-4635

Oracle ORA-24816 inserting and updating data for entities containg LOB attributes

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 3.6.10, 4.1.6
    • Fix Version/s: 4.1.8, 4.3.0.Beta1
    • Component/s: hibernate-core
    • Labels:
      None
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Last commented by a user?:
      true
    • Sprint:

      Description

      Inserting or updating an entity with LOB results in the following error from oracle:

      Caused by: java.sql.SQLException: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column

      Fairly confident that the ordering of the LOB attributes is not putting them at the end of the insert or the update. Oracle requires all LOB columns to be the last in the statement.

        Attachments

          Issue links

          is followed up by

          Bug - A problem which impairs or prevents the functions of the product. HHH-8382 Oracle ORA-24816 - Issue HH4635 solved for annotation, not for hbm version

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. HHH-8705 Unable to persist entity with MappedSuperclass and @Lob in Oracle.

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. HHH-12186 ORA-24816 still occurs for insert statements created by envers

          • Major - Major loss of function.
          • Closed
          links to

          Web Link JBPAPP-9705

            Activity

              People

              • Votes:
                9 Vote for this issue
                Watchers:
                17 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: