带有 AdoNetAppender 的 Log4Net - 没有任何反应 [英] Log4Net with AdoNetAppender - nothing happens

问题描述

说明

我有一个配置文件作为我的程序集中的资源，并且想在我的应用程序中以编程方式更改 ConnectionString.

我使用 log4net.Config.XmlConfigurator.Configure 加载配置.

我有一些断点，看到配置加载成功，连接字符串是Data Source=localhostSQLExpress;Initial Catalog=Log;Integrated Security=SSPI;(本地SQLExpress).>

问题

什么都没有发生，没有例外，也没有日志条目.任何想法.

using (Stream stream = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("MyNamespace.Properties.log4net.config")){//流不为空log4net.Config.XmlConfigurator.Configure(stream);}Hierarchy hier = LogManager.GetRepository() as Hierarchy;如果(hier ！= null){//获取ADONetAppendervar adoAppender = (AdoNetAppender)hier.GetAppenders().Where(appender => appender.Name.Equals("AdoNetAppender", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();如果(adoAppender！= null){//更新连接字符串adoAppender.ConnectionString = configuration.GetConnectionString(ConnectionStringNames.Log).ConnectionString;//刷新appender的设置adoAppender.ActivateOptions();}}ILog 记录器 = LogManager.GetLogger("MyProject");logger.Warn("测试");

log4net.config 文件的内容

<connectionString value="[我们将在运行时自动设置]"/><commandText value="INSERT INTO Log ([Date],[Level],[Logger],[Message],[Exception])VALUES (@log_date, @log_level, @logger, @message, @exception)"/><参数><parameterName value="@log_date"/><dbType value="DateTime"/><layout type="log4net.Layout.RawTimeStampLayout"/></参数><参数><parameterName value="@log_level"/><dbType value="String"/><size value="50"/><layout type="log4net.Layout.PatternLayout"><conversionPattern value="%p"/></布局></参数><参数><parameterName value="@logger"/><dbType value="String"/><size value="255"/><layout type="log4net.Layout.PatternLayout"><conversionPattern value="%c"/></布局></参数><参数><parameterName value="@message"/><dbType value="String"/><size value="4000"/><layout type="log4net.Layout.PatternLayout"><conversionPattern value="%m"/></布局></参数><参数><parameterName value="@exception"/><dbType value="String"/><size value="2000"/><layout type="log4net.Layout.ExceptionLayout"/></参数></appender><根><level value="ALL"/><appender-ref ref="AdoNetAppender"/></root></配置>

解决方案

您可以通过挂钩到 log4net DebugAppender 来调试 log4net:

在您的 app.config 文件中添加 log4net 应用设置:

<!-- 在调试模式下运行时的 log4net 配置.--><add key="log4net.Internal.Debug" value="true"/></appSettings>

在 log4net 配置中添加调试 appender:

<immediateFlush value="true"/><layout type="log4net.Layout.SimpleLayout"/></appender>

将 appender 添加到 log4net 配置根目录:

<level value="ALL"/><appender-ref ref="AdoNetAppender"/><appender-ref ref="DebugAppender"/></root>

运行应用程序时，查看 Visual Studio 的输出窗口，您应该会看到 log4net 的所有内部日志记录.如果没有，则永远不会加载 log4net 配置文件.

编辑

如果您可以使用 app.config 文件中的连接字符串，则从 log4net AdoNetAppender 中删除连接字符串，只需按名称调用连接字符串:

<bufferSize value="1"/><!-- 注意:您可以使用 4.0 程序集--><connectionType value="System.Data.SqlClient.SqlConnection,系统数据，版本=4.0.0.0，文化=中立，PublicKeyToken=b77a5c561934e089"/><!-- 这将从 app.config 中按名称检索连接字符串 --><connectionStringName value="ConnectionStringNameFromAppConfig"/><!-- 剪断--></appender>

Description

I have a config file as a resource in my assembly and want to change the ConnectionString programmatically in my application.

I load the configuration using log4net.Config.XmlConfigurator.Configure.

I have some breakpoints and see that the configuration is loaded successfuly and the connectionstring is Data Source=localhostSQLExpress;Initial Catalog=Log;Integrated Security=SSPI; (local SQLExpress).

Problem

Nothing happens, no exception and no log entry. Any ideas.

using (Stream stream = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("MyNamespace.Properties.log4net.config"))
{ 
    // stream is NOT null
    log4net.Config.XmlConfigurator.Configure(stream);
}

Hierarchy hier = LogManager.GetRepository() as Hierarchy;

if (hier != null)
{
    //get ADONetAppender
    var adoAppender = (AdoNetAppender)hier.GetAppenders().Where(appender => appender.Name.Equals("AdoNetAppender", StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();

    if (adoAppender != null)
    {
        // update connectionstring
        adoAppender.ConnectionString = configuration.GetConnectionString(ConnectionStringNames.Log).ConnectionString;
        //refresh settings of appender
        adoAppender.ActivateOptions(); 
    }
}

ILog logger = LogManager.GetLogger("MyProject"); 
logger.Warn("Test");

content of the log4net.config file

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <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.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
      <connectionString value="[we will set this automatically at runtime]" />
      <commandText value="INSERT INTO Log ([Date],[Level],[Logger],[Message],[Exception])
  VALUES (@log_date, @log_level, @logger, @message, @exception)" />
      <parameter>
        <parameterName value="@log_date" />
        <dbType value="DateTime" />
        <layout type="log4net.Layout.RawTimeStampLayout" />
      </parameter>
      <parameter>
        <parameterName value="@log_level" />
        <dbType value="String" />
        <size value="50" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%p" />
        </layout>
      </parameter>
      <parameter>
        <parameterName value="@logger" />
        <dbType value="String" />
        <size value="255" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%c" />
        </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="2000" />
        <layout type="log4net.Layout.ExceptionLayout" />
      </parameter>
    </appender>

    <root>
      <level value="ALL" />
      <appender-ref ref="AdoNetAppender" />
    </root>
  </log4net>
</configuration>

解决方案

You can debug log4net by hooking into the log4net DebugAppender:

Add a log4net app setting in your app.config file:

<appSettings>
  <!-- log4net configuration when running in debug mode. -->    
  <add key="log4net.Internal.Debug" value="true" />   
</appSettings>

Add a debug appender in the log4net config:

<appender name="DebugAppender" type="log4net.Appender.DebugAppender">
  <immediateFlush value="true" />
  <layout type="log4net.Layout.SimpleLayout" />
</appender>

Add the appender to the log4net config root:

<root>
  <level value="ALL" />
  <appender-ref ref="AdoNetAppender" />
  <appender-ref ref="DebugAppender" />
</root>

When you run your application, look in the output window of Visual Studio and you should see all the internal logging for log4net. If not, then the log4net config file is never loading.

Edit

If you can use a connection string from your app.config file, then remove the connection string from the log4net AdoNetAppender and just call the connection string by name:

<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
  <bufferSize value="1" />
  <!-- note: you can use the 4.0 assembly -->
  <connectionType value="System.Data.SqlClient.SqlConnection,
              System.Data, 
              Version=4.0.0.0, 
              Culture=neutral, 
              PublicKeyToken=b77a5c561934e089" />
  <!-- This will retrieve a connection string by name from the app.config -->
  <connectionStringName value="ConnectionStringNameFromAppConfig" />
  <!-- snip -->
</appender>

这篇关于带有 AdoNetAppender 的 Log4Net - 没有任何反应的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！