I found out the error:
--- Move the commandText line after all the parameter nodes.
Thanks
Arun
nmarun wrote:
>
> Hi Log4Net developers/users,
>
> I'm currently developing a logging mechanism for our company and I'm
> having an issue with the below code - its not working!!
>
> [code]
> <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
> <bufferSize value="100" />
> <threshold value="WARN" />
> <connectionType value="System.Data.SqlClient.SqlConnection, System.Data,
> Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
> <connectionString value="Server=serverName;Database=Log4Net;User
> ID=userID;Password=Password;Trusted_Connection=False" />
> <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.PatternLayout">
> <conversionPattern value="%d{yyyy'-'MM'-'dd
> HH':'mm':'ss'.'fff}" />
> </layout>
> </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="255" />
> <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>
> [/code]
>
> I'm writing a C# web app to test this and after run the code I do not see
> any inserts in the database table. Please help.
>
> Thanks
> Arun
>
--
View this message in context:
http://www.nabble.com/AdoNetAppender-for-SQL-db-issue-tf3670908.html#a10258734
Sent from the Log4net - Users mailing list archive at Nabble.com.
