logging-log4net-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vijay Gandhi Bolla (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (LOG4NET-373) AdoNetAppender truncates the data while inserting into DB
Date Thu, 04 Apr 2013 13:47:15 GMT

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

Vijay Gandhi Bolla commented on LOG4NET-373:

I am using text as datatype of column in the table. It seems text column can store upto 2Gb
of data. But, i am trying to store my serialized object into this column and I am sure this
would not be 2GB size object. 

I am seeing that in the table only 43679 characters are being stored and the serialized object
is of length 93982 characters.

Please, let me know how can I resolve this issue or if there is any workaround.
> AdoNetAppender truncates the data while inserting into DB
> ---------------------------------------------------------
>                 Key: LOG4NET-373
>                 URL: https://issues.apache.org/jira/browse/LOG4NET-373
>             Project: Log4net
>          Issue Type: Bug
>         Environment: SQL Server 2008 R2, VS 2010
>            Reporter: Vijay Gandhi Bolla
>            Priority: Critical
> I am using Log4net to log request and response of my services into SQL server DB. I am
serializing the request and response objects and saving them into DB.
> I have seen that log4net is truncating the xml text and saving it into DB. I am using
string type in the table and also in the appender i have given String as Dbtype and given
the Size value as '2147483647'. 
> But still the text is getting trimmed.
> Please, let me know if this is an issue or am i missing something here.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

View raw message