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)
