Uploaded image for project: 'FUSE ESB'
  1. FUSE ESB
  2. ESB-532

Let's make to the JDBC Auditor service write its data to the database asynchronously.

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 3.3.1.12-fuse
    • Fix Version/s: 4.2.0-fuse-01-00
    • Component/s: Core
    • Labels:
      None
    • Environment:
      FUSE ESB 3.3.x, JDBC Auditor service enabled.
    • Similar Issues:
      Show 10 results 

      Description

      The JDBC Auditor service should write its audit data to the JDBC database asynchronously in order to improve performance. This becomes quite necessary when auditing large messages and also in relation to ESB-513 when writing the message in a proper db format (rather than a blob message), which requires mapping of message fields to db columns and complicates the SQL statements.

        Gliffy Diagrams

          Issue Links

            Activity

            Hide
            rajdavies Rob Davies added a comment -

            Writing asynchronously to the database means that we will either still block eventually, or run out of memory (if we do not use an unbounded Queue). I would suggest using a faster database - or another type of storage - like KahaDB.

            Show
            rajdavies Rob Davies added a comment - Writing asynchronously to the database means that we will either still block eventually, or run out of memory (if we do not use an unbounded Queue). I would suggest using a faster database - or another type of storage - like KahaDB.

              People

              • Assignee:
                rajdavies Rob Davies
                Reporter:
                mielket Torsten Mielke
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: