You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4net-dev@logging.apache.org by "Philip Lee (JIRA)" <ji...@apache.org> on 2015/11/13 11:07:10 UTC

[jira] [Created] (LOG4NET-489) AdoNetAppender fails after upgrade to 2.0.4

Philip Lee created LOG4NET-489:
----------------------------------

             Summary: AdoNetAppender fails after upgrade to 2.0.4
                 Key: LOG4NET-489
                 URL: https://issues.apache.org/jira/browse/LOG4NET-489
             Project: Log4net
          Issue Type: Bug
          Components: Appenders
    Affects Versions: 1.2.14
         Environment: Windows
            Reporter: Philip Lee


with 1.2.13 everything is working fine.
Update to 1.2.14 (2.0.4 on Nuget), logging fails.
I would have attached screenshots, but can't work out how.

For example

    <connectionType
      value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
    <connectionStringName value="LabelPrint" />
    <commandText
      value="INSERT INTO dbo.Logging ([LogDate],[Level],[Operation],[OperationInfo],[User],[Label],[Application],[CorrelationId],[Method],[Line],[Logger],[Message],[Exception]) 
                 VALUES (@log_date, @log_level, @operation, @operationInfo, @user, @label, @application, @correlationId, @pgm_method, @pgm_line, @logger, @message, @exception)" />
    <parameter>
      <parameterName value="@log_date" />
      <dbType value="DateTime" />
      <layout type="log4net.Layout.RawUtcTimeStampLayout" />
    </parameter>
    ... etc

This now causes the error 

'Exception while writing to database System.IndexOutOfRangeException: An SqlParameter with ParamerName '@log_date' is not contained by this SqlParameterCollection ....





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)