[#ESB-532] Let's make to the JDBC Auditor service write its data to the database asynchronously.

FUSE ESB

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

Created: 06/Jan/09 10:04 AM Updated: 18/Jun/09 02:34 PM

Component/s:

Core

Affects Version/s:

3.3.1.12-fuse

Fix Version/s:

4.2.0-fuse-01-00

Environment:

FUSE ESB 3.3.x, JDBC Auditor service enabled.

Issue Links:

Linked

This issue is linked to:

ESB-513 JDBC Auditor service to store message exchanges in proper format rather than only SQL BLOBs

Description

« Hide

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.

All

Comments

Change History

Sort Order:

[ Permlink | « Hide ]

Rob Davies added a comment - 18/Jun/09 02:34 PM

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.