(1)
public void Info(object message, Exception ex, object additional)
{
if (Logger.IsEnabledFor(Level.Info))
{
LoggingEvent loggingEvent = new LoggingEvent(
declaringType,
Logger.Repository,
Logger.Name,
Level.Info,
message,
ex);
loggingEvent.Properties["additional"] = additional;
Logger.Log(loggingEvent);
}
}
I just did same thing few days ago :) (thx to log4net.Ext.EventID)
It works like charm.
(3)
If the call looks like this:
log.Info("Oh no!", ex, 1234);
I can access 1234 by using the property pattern:
<conversionPattern value="%property{additional}" />
yes, yes, I know it should work like this.... and it does, but ( this
is interesting):
When I used Integrated Security in my connection string and with
<conversionPattern value="%property" />
everything is fine (because log4net impersonates 'me' when connecting
to database)
and when I'm using
<conversionPattern value="%property{additional}" />
it stops logging (because log4net tries to connect to db as ASPNET,
and I naturally forgot to give ASPNET rights for db)
I simply solved this by using user and psw in connection string (this
is what I intended to do from beginning).
(4)
If you configure log4net using the ConfigureAndWatch method ...
log4net will attempt to reload itself when the configuration file
changes.
I was using ConfigureAndWatch and this is still problem for me.
When I make any changes in log4net.config they are reloaded instantly,
but when I make same error in log4net.config, logging won't work. And if I then
correct this error logging still won't work until I restart my web application.
--- puska <[EMAIL PROTECTED]> wrote:
> Hi
>
> What I'm trying to do is to include new field (column) in Sql DB,
> with some
> additional business related information.
> I need this optional info (parameter) in NEW column for fastest
> browsing and
> searching.
> Idea is to call log from application with new parameter:
> log.Info("My message","Some business data");
> // or log.Info("My message", ex, "Some business data"); // with
> Exception
>
> I'm already using custom wrapper for log4net, so I easily overloaded
> Info
> function:
> public void Info(object message, Exception ex, object additional)
> {
> using
> (log4net.LogicalThreadContext.Stacks["additional"].Push(
> additional.ToString()))
> {
> this.Logger.Logger.Log(
> _declaringType,
> log4net.Core.Level.Info,
> message,
> ex);
> }
> }
>
> and I put new parameter in SQLAdoAppender (in config file):
> <parameter>
> <parameterName value="@Additional" />
> <dbType value="String" />
> <size value="1024" />
> <layout type="log4net.Layout.PatternLayout">
> <conversionPattern value="%property" />
> </layout>
> </parameter>
>
> and this is working (almost) fine.
>
> My questions are:
> 1. Is there any better (fastest) way for doing this?
> 2. My additional parameter is strictly related to called logging
> event.
> Would I have on this way interference with other logs?
> 3. How to get only my additional info from property? I tried this,
> but it's
> not working:
> <conversionPattern value="%property{additional}" />
> 4. when I make some error in configuration file (like one above) and
> then
> correct it, logging won't work until I restart my web application?!
>
> Thanks, Mario
>
>
> PS I'm using log4net-1.2.10 in my ASP.NET 2.0 application
>
