Hey, Georg, worked great - thanks for all your help!!!
Harry Douglass
Consumer Lending Application Development
X2-1035
"Georg Jansen"
<[EMAIL PROTECTED]
tNet.com> To
"'Log4NET User'"
09/07/2006 01:42 <[email protected]>
AM cc
Subject
Please respond to RE: How to pass data to custom
"Log4NET User" ADONetAppender parameters?
<[EMAIL PROTECTED]
ging.apache.org>
Sorry, an error in the parameter definition in my previous mail.
Harry,
Inserting custom data using the AdoNetAppender si pretty straight forward,
first you have to modify the sql statement in the configuration file to
something like:
<commandText value="INSERT INTO Log4Net
([Date],[Thread],[Level],[Logger],[Message],[Exception],[MyColumn]) VALUES
(@log_date, @thread, @log_level, @logger, @message, @exception,@MyColumn)"
/>
And add a new parameter definition for the custom column for example like:
<parameter>
<parameterName value="@MyColumn "/>
<dbType value="String" />
<size value="255" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%property{MyColumn}" />
</layout>
</parameter>
Then you use one of log4net’s contexts to transfer values to the parameter
for example:
log4net.GlobalContext.Properties["MyColumn"] = "MyValue";
log.Debug("My message")
Best regards
Georg
http://www.l4ndash.com - Log4net Dashboard
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 6. september 2006 21:18
To: Log4NET User
Subject: How to pass data to custom ADONetAppender parameters?
Hello,
I am trying to find a way to write my own custom parameters that I would
log
to a SQL Server Database. I am a newbie to this, so I got the
"out-of-the-box" implementation of logging an exception, message, dates
that
writes to SQL Server using the ADONetAppender. However, I want to pass my
own custom data variables to the database. So, my DB table would have
these
fields:
Table name = CustomStuff
Custom Log Fields:
MyCustomMessage
MyCustomContactName
MyCustomPhoneNumber
I found code that creates a custom ADONetAppender, but there's more to it
and I can seem to bridge even how that would translate into C# code on how
to pass this data in the parameters.
I hope what I am asking makes sense, but if not I can provide more details.
Thanks in advance,
Harry
The contents of this email are the property of PNC. If it was not addressed
to you, you have no legal right to read it. If you think you received it in
error, please notify the sender. Do not forward or copy without permission
of the sender. This message may contain an advertisement of a product or
service and thus may constitute a commercial electronic mail message under
US Law. PNCs postal address is 249 Fifth Avenue, Pittsburgh, PA 15222. If
you do not wish to receive any additional advertising or promotional
messages from PNC at this e-mail address, click here to Unsubscribe.
https://pnc.p.delivery.net/m/u/pnc/uni/p.asp By unsubscribing to this
message, you will be unsubscribed from all advertising or promotional
messages from PNC. Removing your e-mail address from this mailing list will
not affect your subscription to alerts, e-newsletters or account servicing
e-mails..
The contents of this email are the property of PNC. If it was not addressed to
you, you have no legal right to read it. If you think you received it in error,
please notify the sender. Do not forward or copy without permission of the
sender. This message may contain an advertisement of a product or service and
thus may constitute a commercial electronic mail message under US Law. PNC�s
postal address is 249 Fifth Avenue, Pittsburgh, PA 15222. If you do not wish to
receive any additional advertising or promotional messages from PNC at this
e-mail address, click here to Unsubscribe.
https://pnc.p.delivery.net/m/u/pnc/uni/p.asp By unsubscribing to this message,
you will be unsubscribed from all advertising or promotional messages from PNC.
Removing your e-mail address from this mailing list will not affect your
subscription to alerts, e-newsletters or account servicing e-mails..
