Uploaded image for project: 'JBoss Enterprise Application Platform 6'
  1. JBoss Enterprise Application Platform 6
  2. JBPAPP6-1220

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

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: EAP 6.0.0
    • Fix Version/s: EAP 6.1.0
    • Component/s: Hibernate
    • Labels:
      None
    • Environment:

      EAP 6 GA

    • Workaround Description:
      Hide

      Renaming the CLOB property to something starting in "zz". This will guarantee that it will be positioned in the final of the statement.

      Show
      Renaming the CLOB property to something starting in "zz". This will guarantee that it will be positioned in the final of the statement.

      Description

      https://hibernate.onjira.com/browse/HHH-4635

      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.

      The Jira HHH-4635 has a test case and a possible fix attached

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                brmeyer Brett Meyer
                Reporter:
                alessandrolt Alessandro Lazarotti
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: