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

Hibernate Envers creates unnecessary audit rows for tables with LOB data

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects versions: 5.1.0
    • Fix versions: 5.0.10, 5.2.0, 5.1.1
    • Components: hibernate-envers
    • Labels:
      None
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

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

      Description

      Given an audited entity that contains an audited @Lob byte[] field and some other non audited field (annotated with @NotAudited), an audit row will be incorrectly inserted whenever the non audited field is modified.

      The impact of this issue can be very significant if the @Lob byte[] field contains a large amount of binary data such as images, and the non-audited field is updated very frequently, as this will cause very rapid growth of the audit table.

      Note that the issue can be worked around by using a String data type annotated with @Lob instead of byte[], and base64 encoding the binary data.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: