自己最近用到的log4net写入oracle的配置,总结一下吧

<!--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");
        }