Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-24006

Long comment in AuditLogger's LogEntry (SQL based) throws exception

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 8.10-HF20
    • Fix Version/s: None
    • Component/s: Audit

      Description

      When trying to put a long comment in the audit trail via the AuditLogger service with a SQL backend (PgSQL in our case), the call fails with a org.hibernate.exception.DataException: Could not execute JDBC batch update exception (see attached file).

      The problem lies in the size of the column for the comment which is set to 1024 characters when using JPA based LogEntry.

      On our side, we opted for abbreviating the comment before sending is to the AudiLogger, but we think it would be nice to have the AuditLogger either accept longer comments, or maybe abbreviating it (even though it might feel disturbing for users of the AuditLogger).

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: