[
https://issues.apache.org/jira/browse/LOG4NET-489?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15004650#comment-15004650
]
Philip Lee edited comment on LOG4NET-489 at 11/13/15 8:16 PM:
--------------------------------------------------------------
Yes I can confirm that fixes the issue.
was (Author: impphil2):
Yes that worked.
> 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)
