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 14:14:10 UTC

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

     [ https://issues.apache.org/jira/browse/LOG4NET-489?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Philip Lee updated LOG4NET-489:
-------------------------------
    Attachment: screenshot-1.png

> 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
>            Assignee: Dominik Psenner
>         Attachments: screenshot-1.png
>
>
> 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)