[ 
https://issues.apache.org/jira/browse/LOG4NET-28?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12564471#action_12564471
 ] 

Greg Peterson commented on LOG4NET-28:
--------------------------------------

The PatternLayout uses SystemInfo.NullText which returns a string "(null)" not 
the null value. If you use a custom property and set it to null, you will not 
have the parameter set to DBNull.

The PatternConverter.WriteObject(TextWriter writer, ILoggerRepository 
repository, object value) calls repository.RendererMap.FindAndRender(value, 
writer);

which in turn, sets the value to "(null)" because the object value is null.

if (obj == null)
                        {
                                writer.Write(SystemInfo.NullText);
                        }
                        else 
                        {
.....

> AdoNetAppender does not support inserting NULL into columns
> -----------------------------------------------------------
>
>                 Key: LOG4NET-28
>                 URL: https://issues.apache.org/jira/browse/LOG4NET-28
>             Project: Log4net
>          Issue Type: Bug
>          Components: Appenders
>    Affects Versions: 1.2.9
>            Reporter: Nicko Cadell
>            Assignee: Nicko Cadell
>            Priority: Minor
>             Fix For: 1.2.10
>
>
> The AdoNetAppender does not support inserting NULL values into columns.
> If a column allows NULL values then the AdoNetAppender should allow NULL 
> values to be inserted. For most value types this means using the DBNull value 
> for the parameter. The AdoNetAppenderParameter should convert CLI null values 
> into DBNull values before setting the parameter value.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to