Logging API: How to store logs in database?

[Former Member]

Hello!

We are using SAP logging API and i saw there are three several ways to output logs:

1.) FileLog

2.) ConsoleLog

3.) StreamLog

Is it possible to store the Log Files in a database table (for example of an MS SQL Server) ?

[Former Member]

Hi,

Sorry, there is no good way I could think of. In theory you could plugin in a new implementation of some of the API interfaces :

For example http://help.sap.com/javadocs/NW04S/current/en/com/sap/tc/logging/Formatter.html

Than as a side effect of formatting to insert the data into the DB as well. But that looks more of a hack to me.

Another way would be to have some XMLFormatter and log to a file with XML format, then to have some background process that will insert into DB as well as delete / archive the old data ...

HTH

Peter