Re: AdoNetAppender field sizes

[Ron Grabowski]

The config looks correct to me. Are you sure you want to use the .NET 1.0 
version of System.Data? Does this make a difference?

<connectionTypevalue="System.Data.SqlClient.SqlConnection, System.Data" />



----- Original Message ----
From: "Watson, Gary" <gary.wat...@nustarenergy.com>
To: "log4net-user@logging.apache.org" <log4net-user@logging.apache.org>
Sent: Mon, May 10, 2010 8:19:48 AM
Subject: AdoNetAppender field sizes

Hello,

I am using the AdoNetAppender in log4net to write error messages to a SQL 
Server 2000 database.   Here is the configuration I am using, taken from my 
app.config file:

  <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="Data Source=MHL1\SQL2000;Initial 
Catalog=Stocks;Integrated Security=true;" />
      <commandText value="INSERT INTO Log 
([Date],[Thread],[Level],[Logger],[Message],[Exception],[Context],[Username]) 
VALUES 
         (@log_date, @thread, @log_level, @logger, @message, @exception, 
@context, @username)" />
      <parameter>
        <parameterName value="@log_date" />
        <dbType value="DateTime" />
        <layout type="log4net.Layout.RawTimeStampLayout" />
      </parameter>
      <parameter>
        <parameterName value="@thread" />
        <dbType value="String" />
        <size value="32" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%t" />
        </layout>
      </parameter>
      <parameter>
        <parameterName value="@log_level" />
        <dbType value="String" />
        <size value="512" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%p" />
        </layout>
      </parameter>
      <parameter>
        <parameterName value="@context" />
        <dbType value="String" />
        <size value="512" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%x" />
        </layout>
      </parameter>
      <parameter>
        <parameterName value="@logger" />
        <dbType value="String" />
        <size value="512" />
        <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>
      <parameter>
        <parameterName value="@username" />
        <dbType value="String" />
        <size value="8" />
        <layout type="log4net.Layout.PatternLayout">
          <conversionPattern value="%X{username}" />
        </layout>
      </parameter>
    </appender>
    <root>
      <level value="ALL" />
      <appender-ref ref="ADONetAppender" />
    </root>
  </log4net>


I have created the "Log" table as referenced in the "CommandText" property with 
fields having the same names and sizes for each of the parameters.  As you can 
see, the "@exception" parameter has a specified size of 2000 characters.  
However, the "Exception" values that are stored in the table after errors occur 
appear to be truncated at 256 characters.

The code I am using to configure log4net is as follows:

        log4net.Config.XmlConfigurator.Configure()
        Dim h As log4net.Repository.Hierarchy.Hierarchy = 
CType(LogManager.GetRepository(), Repository.Hierarchy.Hierarchy)
        Dim ado As Appender.AdoNetAppender = 
CType(h.Root.GetAppender("ADONetAppender"), Appender.AdoNetAppender)
        ado.ConnectionString = CGlobals.log4netConnectionString
        ado.ActivateOptions()
        log4net.GlobalContext.Properties("username") = Environment.UserName

And when storing the error, here is the code that I use:

        Using log4net.NDC.Push(sContext)
            Dim l4nLog As ILog = 
LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)
            l4nLog.Error(sMessage)
        End Using

Can anybody shed some light as to why this is happening?  I am not truncating 
anything in code, and also cannot see anything in the log4net source to 
indicate that this would be happening there either.

Thanks,
Gary