[ https://issues.apache.org/jira/browse/LOG4NET-202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Stefan Bodewig updated LOG4NET-202: ----------------------------------- Affects Version/s: 1.2.11 Fix Version/s: (was: 1.2 Maintenance Release) 1.2.12 I have changed the documentation in svn to recommend using -1 explicitly but it would if anybody could confirm this actually works before I close the issue (and update the site). > AdoNetAppenderParameter.Size Property is not optional > ----------------------------------------------------- > > Key: LOG4NET-202 > URL: https://issues.apache.org/jira/browse/LOG4NET-202 > Project: Log4net > Issue Type: Bug > Components: Documentation > Affects Versions: 1.2.10, 1.2.11 > Environment: Windows Server 2008, .NET 3.5 SP1, SQL Server 2008 > Reporter: Richard Dingwall > Fix For: 1.2.12 > > Original Estimate: 0.5h > Remaining Estimate: 0.5h > > The AdoNetAppenderParameter.Size page > (http://logging.apache.org/log4net/release/sdk/log4net.Appender.AdoNetAppenderParameter.Size.html) > says "This property is optional. If not specified the ADO.NET provider will > attempt to infer the size from the value." > However, I just got the following exception in the log4net internal debug > trace, with the following parameter (maps to a VARCHAR(MAX)): > <parameter> > <parameterName value="@exception" /> > <dbType value="String" /> > <layout type="log4net.Layout.ExceptionLayout" /> > </parameter> > log4net:ERROR [AdoNetAppender] Could not prepare database command [INSERT > INTO ....] > System.InvalidOperationException: SqlCommand.Prepare method requires all > variable length parameters to have an explicitly set non-zero Size. > at System.Data.SqlClient.SqlParameter.Prepare(SqlCommand cmd) > at System.Data.SqlClient.SqlCommand.Prepare() > at log4net.Appender.AdoNetAppender.InitializeDatabaseCommand() > This would suggest the Size parameter cannot be null. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira