How to log request/response data into SQLserver database

[lekkie_lomotayo]

Hi Guys,

I need to log every message entering and leaving my FUSE ESB in an sql database.

How do I achieve this?

I am hoping I will not have to develop (application) a pass through service that will log this in to a database.

Does Fuse have anything like this.

The purpose is to track request/response/status of all messages.

kr.

[davestanley]

You should be able to use servicemix-audit/the jdbc auditor for this:

See: /core/servicemix-audit/src/main/java/org/apache/servicemix/jbi/audit/jdbc/JdbcAuditor.java

Regards,

/Dave

[lekkie_lomotayo]

Thanks for the quick response.

I am actually working with the Fuse Integration Designer, Any Idea how I can use this in the tool?

I know I can install the feature from servicemix console with features/install nmr-audit. Is there a suport for using this feature in Fuse Integration Designer?

kr.

[gseben]

I don't think there is support for this in the FID.

-Gio

[lekkie_lomotayo]

I figured out what I needed to do to deploy the audit stuff. Thanks.

Do you know where I can get the OSGi bundle for mssql server or preferably how to install SQLServer instead of HSQLDB?

The sample shows for HSQLDB:

osgi/install -s wrap:mvn:hsqldb/hsqldb/1.8.0.7

kr.

Edited by: lekkie on Nov 2, 2009 7:45 PM