Log4Net的坎坷配置之旅。

第一步：引入dll

第二步：新建log4net.Config

第三步：AssemblyInfo.cs植入log4net.Config

              [assembly: XmlConfigurator(ConfigFile = "Log4Net.config", Watch = true)]

第四步:Global.asax新增Application_Error

      protected void Application_Error(object sender, EventArgs e) {
             Exception objErr = Server.GetLastError().GetBaseException();
             log4net.ILog log = log4net.LogManager.GetLogger("小苹果-system-Administartor");
             log.Error(objErr.Message,objErr);
         }

附：

<?xml version="1.0" encoding="utf-8"?><log4net>  <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">    <bufferSize value="1" />   <span style="font-size:18px;"> <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />(sql2008哦！)</span>    <connectionString value="Data Source=192.168.0.226;Initial Catalog=YourDB;Persist Security Info=True;User ID=sa;Password=123456" />    <commandText value="INSERT INTO Admin_Log4Net ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" />    <parameter>      <parameterName value="@log_date" />      <dbType value="DateTime" />      <layout type="log4net.Layout.RawTimeStampLayout" />    </parameter>    <parameter>      <parameterName value="@thread" />      <dbType value="String" />      <size value="255" />      <layout type="log4net.Layout.PatternLayout">        <conversionPattern value="%thread" />      </layout>    </parameter>    <parameter>      <parameterName value="@log_level" />      <dbType value="String" />      <size value="50" />      <layout type="log4net.Layout.PatternLayout">        <conversionPattern value="%level" />      </layout>    </parameter>    <parameter>      <parameterName value="@logger" />      <dbType value="String" />      <size value="255" />      <layout type="log4net.Layout.PatternLayout">        <conversionPattern value="%logger" />      </layout>    </parameter>    <parameter>      <parameterName value="@message" />      <dbType value="String" />      <size value="4000" />      <layout type="log4net.Layout.PatternLayout">        <conversionPattern value="%message" />      </layout>    </parameter>    <parameter>      <parameterName value="@exception" />      <dbType value="String" />      <size value="2000" />      <layout type="log4net.Layout.ExceptionLayout" />    </parameter>  </appender>  <root>    <!-- Set this to "ERROR" before release -->    <!--Highest: OFF->FATAL->RROR->WARN->INFO->DEBUG->ALL :Lowest -->    <level value="ALL" />    <appender-ref ref="AdoNetAppender" />    <!-- <appender-ref ref="SmtpAppender" /> -->    <!--<appender-ref ref="FileAppender" /> -->  </root></log4net>

结果：只插了几次就插不进去了。

全盘诊断：

原来是Ibatis的日志功能占用了！

注释掉Ibatis的日志功能：

<iBATIS>
    <!--<logging>
      <logFactoryAdapter type="IBatisNet.Common.Logging.Impl.Log4NetLoggerFA, IBatisNet.Common.Logging.Log4Net">
        <arg key="configType" value="inline" />
        <arg key="showLogName" value="true" />
        <arg key="showDataTime" value="true" />
        <arg key="level" value="ALL" />
        <arg key="dateTimeFormat" value="yyyy/MM/dd HH:mm:ss:SSS" />
      </logFactoryAdapter>
    </logging>-->
  </iBATIS>

一切恢复正常。