getting AsoNetAppender to work
------------------------------
Key: LOG4NET-152
URL: https://issues.apache.org/jira/browse/LOG4NET-152
Project: Log4net
Issue Type: Improvement
Affects Versions: 1.2.10
Environment: windows asp.net c#
Reporter: m
I've been trying to get log4net to work with asp.net 2.0 and a database table.
Here is the config file:
<configSections>
<section name="log4net"
type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
</configSections>
<log4net>
<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
<bufferSize value="1" />
<connectionType value="System.Data.SqlClient.SqlConnection, System.Data,
Version=1.2.10.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<connectionString value="server=CJISDEVSQL01;database=EventLog;integrated
security=true;" />
<commandText value="exec LD80Event_CREATE @eventDate, @logLevel, @message,
@exception, @updateUserName" />
<parameter>
<parameterName value="@eventDate" />
<dbType value="DateTime" />
<layout type="log4net.Layout.RawTimeStampLayout" />
</parameter>
<parameter>
<parameterName value="@logLevel" />
<dbType value="String" />
<size value="512" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%p" />
</layout>
</parameter>
<parameter>
<parameterName value="@message" />
<dbType value="String" />
<size value="4000" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%m" />
</layout>
</parameter>
<parameter>
<parameterName value="@exception" />
<dbType value="String" />
<size value="4000" />
<layout type="log4net.Layout.ExceptionLayout" />
</parameter>
<parameter>
<parameterName value="@updateUserName" />
<dbType value="String" />
<size value="50" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%p" />
</layout>
</parameter>
</appender>
<logger name="eventLog">
<level value="ALL" />
<appender-ref ref="AdoNetAppender" />
</logger>
<root>
<level value="ALL" />
<appender-ref ref="AdoNetAppender" />
</root>
</log4net>
This is the line of code in Global.asax, Application_Start method:
log4net.Config.XmlConfigurator.Configure();
This is in the default page:
private static readonly ILog eventLog =
LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
The issue is all the properties are 'always' set to false when the application
is running and 'nothing' is ever written to the database. I have been searching
the web for a week now and I can not find any information that has made a
difference.
Can you help with this problem?
Thank you.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
