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)