[
https://issues.apache.org/jira/browse/LOG4NET-659?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
fengweiye updated LOG4NET-659:
------------------------------
Description:
my log4net config sqlServer Set the following
<appender name="AdoNetAppender"
type="log4net.Appender.AdoNetAppender"><appender name="AdoNetAppender"
type="log4net.Appender.AdoNetAppender"> <bufferSize value="100" />
<connectionType value="System.Data.SqlClient.SqlConnection, System.Data,
Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<connectionString value="data source=(localdb)\MSSQLLocalDB;initial
catalog=MockSchoolDB;integrated security=false;persist security info=True;User
ID=sa;Password=123456" /> <commandText value="INSERT INTO Log
([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date,
@thread, @log_level, @logger, @message, @exception)" /> <parameter>
<parameterName value="@log_date" /> <dbType value="DateTime" /> <layout
type="log4net.Layout.RawTimeStampLayout" /> </parameter> <parameter>
<parameterName value="@thread" /> <dbType value="String" /> <size value="255"
/> <layout type="log4net.Layout.PatternLayout"> <conversionPattern
value="%thread" /> </layout> </parameter> <parameter> <parameterName
value="@log_level" /> <dbType value="String" /> <size value="50" /> <layout
type="log4net.Layout.PatternLayout"> <conversionPattern value="%level" />
</layout> </parameter> <parameter> <parameterName value="@logger" /> <dbType
value="String" /> <size value="255" /> <layout
type="log4net.Layout.PatternLayout"> <conversionPattern value="%logger" />
</layout> </parameter> <parameter> <parameterName value="@message" /> <dbType
value="String" /> <size value="4000" /> <layout
type="log4net.Layout.PatternLayout"> <conversionPattern value="%message" />
</layout> </parameter> <parameter> <parameterName value="@exception" /> <dbType
value="String" /> <size value="2000" /> <layout
type="log4net.Layout.ExceptionLayout" /> </parameter> </appender><root>
<appender-ref ref="AdoNetAppender"/>
</root>
Environment: .net core 3.1
Summary: Using log4net to put data to the database under .net core 3.1
is invalid (was: Using log4net to log data to the database under the framework
of .net core 3.1 is invalid)
> Using log4net to put data to the database under .net core 3.1 is invalid
> ------------------------------------------------------------------------
>
> Key: LOG4NET-659
> URL: https://issues.apache.org/jira/browse/LOG4NET-659
> Project: Log4net
> Issue Type: Improvement
> Components: Appenders
> Affects Versions: 2.0.8
> Environment: .net core 3.1
> Reporter: fengweiye
> Priority: Major
>
> my log4net config sqlServer Set the following
>
> <appender name="AdoNetAppender"
> type="log4net.Appender.AdoNetAppender"><appender name="AdoNetAppender"
> type="log4net.Appender.AdoNetAppender"> <bufferSize value="100" />
> <connectionType value="System.Data.SqlClient.SqlConnection, System.Data,
> Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
> <connectionString value="data source=(localdb)\MSSQLLocalDB;initial
> catalog=MockSchoolDB;integrated security=false;persist security
> info=True;User ID=sa;Password=123456" /> <commandText value="INSERT INTO Log
> ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date,
> @thread, @log_level, @logger, @message, @exception)" /> <parameter>
> <parameterName value="@log_date" /> <dbType value="DateTime" /> <layout
> type="log4net.Layout.RawTimeStampLayout" /> </parameter> <parameter>
> <parameterName value="@thread" /> <dbType value="String" /> <size value="255"
> /> <layout type="log4net.Layout.PatternLayout"> <conversionPattern
> value="%thread" /> </layout> </parameter> <parameter> <parameterName
> value="@log_level" /> <dbType value="String" /> <size value="50" /> <layout
> type="log4net.Layout.PatternLayout"> <conversionPattern value="%level" />
> </layout> </parameter> <parameter> <parameterName value="@logger" /> <dbType
> value="String" /> <size value="255" /> <layout
> type="log4net.Layout.PatternLayout"> <conversionPattern value="%logger" />
> </layout> </parameter> <parameter> <parameterName value="@message" /> <dbType
> value="String" /> <size value="4000" /> <layout
> type="log4net.Layout.PatternLayout"> <conversionPattern value="%message" />
> </layout> </parameter> <parameter> <parameterName value="@exception" />
> <dbType value="String" /> <size value="2000" /> <layout
> type="log4net.Layout.ExceptionLayout" /> </parameter> </appender><root>
> <appender-ref ref="AdoNetAppender"/>
> </root>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
