log4net输出到IBM DB2问题解决记录

Apache网站上有详细的配置示例：

http://logging.apache.org/log4net/release/config-examples.html

包括输出到各种数据库的Appender，使用下来输出到DB2（V9.7）是有问题的，甚至连接都连不上。

<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">    <bufferSize value="100" />    <connectionType value="IBM.Data.DB2.DB2Connection,IBM.Data.DB2, Version=8.1.2.1" />    <connectionString value="server=192.168.0.0;database=dbuser;user Id=username;password=password;persist security info=true" />    <commandText value="INSERT INTO myschema.Log (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="500" />        <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>

改为下面的OLEDB方式后，可以将常量输出到数据库，但不支持参数：

<connectionType value="System.Data.OleDb.OleDbConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /><connectionString value="Provider=IBMDADB2;Data Source=MYDB;UID=user;PWD=password;" />     

在网上搜索了一下也没有解决方法。

最后，不断尝试下终于解决，只需要将commandText中的参数写成“?”即可，完整的Appender配置如下：

    <appender name="DB2Appender" type="log4net.Appender.AdoNetAppender">      <bufferSize value="1" />     <connectionType value="System.Data.OleDb.OleDbConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />      <connectionString value="Provider=IBMDADB2;Data Source=MYDB;UID=user;PWD=password;" />     <commandText value="INSERT INTO TCLIENTLOG (LOG_TIME, LOG_LEVEL, LOG_THREAD, LOG_MESSAGE) VALUES (?, ?, ?, ?)" /><parameter>        <parameterName value="@log_time" />        <dbType value="String" />        <size value="25" />        <layout type="log4net.Layout.PatternLayout">          <conversionPattern value="%date" />        </layout>      </parameter>      <parameter>        <parameterName value="@log_level" />        <dbType value="String" />        <size value="10" />        <layout type="log4net.Layout.PatternLayout">          <conversionPattern value="%level" />        </layout>      </parameter>      <parameter>        <parameterName value="@log_thread" />        <dbType value="String" />        <size value="10" />        <layout type="log4net.Layout.PatternLayout">          <conversionPattern value="%thread" />        </layout>      </parameter>      <parameter>        <parameterName value="@log_message" />        <dbType value="String" />        <size value="200" />        <layout type="log4net.Layout.PatternLayout">          <conversionPattern value="%message" />        </layout>      </parameter>    </appender>