<!--Web.config文件方式-->
<!--Web.config文件需要配置的内容-->
<configuration>
<!--日志配置部分-->
<configSections>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/>
</configSections>
<!--站点配置部分-->
<log4net>
<!--写入到数据库-->
<appender name="AdoNetAppender_Oracle" type="log4net.Appender.AdoNetAppender">
<connectionType value="System.Data.OracleClient.OracleConnection, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
<connectionString value="server=[your database];uid=[your ID];pwd=[your PWD];pooling=true;max pool size=1000" />
<commandText value="INSERT INTO Base_ErrorLog (SYSTEMNAME, LOG_DATE, THREAD, LOG_LEVEL, LOGGER, MESSAGE) VALUES (:systemname, :log_date, :thread, :log_level, :logger, :message)" />
<bufferSize value="1" />
<!--字段1-->
<parameter>
<parameterName value=":systemname" />
<dbType value="String" />
<size value="100"/>
<layout type="log4net.Layout.PatternLayout" value="MIC.ECP.IES">
<conversionPattern value=""/>
</layout>
</parameter>
<!--字段2-->
<parameter>
<parameterName value=":log_date"/>
<dbType value="DateTime"/>
<!--
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}" />
</layout>
-->
<layout type="log4net.Layout.PatternLayout" value="%date{yyyy'-'MM'-'dd HH':'mm':'ss'.'fff}"/>
</parameter>
<!--字段3-->
<parameter>
<parameterName value=":thread" />
<dbType value="String" />
<size value="50" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%thread" />
</layout>
</parameter>
<!--字段4-->
<parameter>
<parameterName value=":log_level" />
<dbType value="String" />
<size value="50" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%level" />
</layout>
</parameter>
<!--字段5-->
<parameter>
<parameterName value=":logger" />
<dbType value="String" />
<size value="200" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%logger" />
</layout>
</parameter>
<!--字段6-->
<parameter>
<parameterName value=":message" />
<dbType value="String" />
<size value="4000" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%message" />
</layout>
</parameter>
</appender>
<root>
<level value="ALL"/>
<appender-ref ref="AdoNetAppender_Oracle"/>
</root>
</log4net>
</configuration>
<!--Global.asax.cs文件需要配置的内容-->
protected void Application_Start(object sender, EventArgs e)
{
// 在应用程序启动时运行的代码
log4net.Config.XmlConfigurator.Configure();
}
protected void Application_Error(object sender, EventArgs e)
{
// 在出现未处理的错误时运行的代码
Exception objErr = Server.GetLastError().GetBaseException();
log4net.ILog log = log4net.LogManager.GetLogger(Request.Url.ToString());
log.ErrorFormat("发生异常页:{0}<br>异常信息{1}<br>source:{2}", Request.Url.ToString(), objErr.Message, objErr.StackTrace);
Server.ClearError();
//跳转到错误页面
//GoErrorPage(objErr.Message,"~/Default.aspx");
}
自己最近用到的log4net写入oracle的配置,总结一下吧
最新推荐文章于 2021-09-06 20:38:20 发布