Return-Path: Delivered-To: apmail-logging-log4net-user-archive@www.apache.org Received: (qmail 8704 invoked from network); 23 Jul 2008 12:07:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 23 Jul 2008 12:07:12 -0000 Received: (qmail 11099 invoked by uid 500); 23 Jul 2008 12:07:10 -0000 Delivered-To: apmail-logging-log4net-user-archive@logging.apache.org Received: (qmail 11071 invoked by uid 500); 23 Jul 2008 12:07:09 -0000 Mailing-List: contact log4net-user-help@logging.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Log4NET User" List-Id: Delivered-To: mailing list log4net-user@logging.apache.org Received: (qmail 11060 invoked by uid 99); 23 Jul 2008 12:07:09 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Jul 2008 05:07:09 -0700 X-ASF-Spam-Status: No, hits=3.2 required=10.0 tests=HTML_MESSAGE,MSGID_MULTIPLE_AT,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [82.77.20.73] (HELO mail.rms.ro) (82.77.20.73) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 Jul 2008 12:06:14 +0000 Received: from mail.rms.ro (localhost.localdomain [127.0.0.1]) by filter.rms.local (Postfix) with ESMTP id 783CC40DFF8 for ; Wed, 23 Jul 2008 15:06:08 +0300 (EEST) Received: from wksale (pc227.rms.intern [192.168.100.227]) by mail.rms.ro (Postfix) with ESMTP id 5EA3240DFC9 for ; Wed, 23 Jul 2008 15:06:08 +0300 (EEST) From: "Andrei Leca" To: Subject: FW: AdoNetAppender: can not read custom properties from LoggingEvent using configuration file Date: Wed, 23 Jul 2008 15:06:04 +0300 Message-ID: <003601c8ecbc$7b244340$716cc9c0$@leca@rms.ro> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0037_01C8ECD5.A0717B40" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcjsvCHJY3xhQUCfRyOIHWtbmxoLpwAAD05Q Content-Language: en-us X-Virus-Scanned: ClamAV on mail.rms.ro X-Virus-Checked: Checked by ClamAV on apache.org This is a multipart message in MIME format. ------=_NextPart_000_0037_01C8ECD5.A0717B40 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I used a extended log using example: http://svn.apache.org/viewvc/logging/log4net/trunk/extensions/net/1.0/log4ne t.Ext.EventID/cs/src/EventIDLogImpl.cs?view=co . I have properties InstanceId that is setted in extended log: LoggingEvent loggingEvent = new LoggingEvent(ThisDeclaringType, Logger.Repository, Logger.Name, Level.Info, message, exc); loggingEvent.Properties["InstanceId"] = logData.DCSInstanceId; Logger.Log(loggingEvent); I received error: [6108] log4net:ERROR XmlHierarchyConfigurator: Cannot find Property [conversionPattern] to set object on [log4net.Appender.AdoNetAppenderParameter] Where it is the problem? Do you can help me? The logs works correctly if uses other appender: "log4net.Appender.OutputDebugStringAppender" I used log4net 1.2.10.0(windows) with following configuration for log4net: Have a nice day Andy ------=_NextPart_000_0037_01C8ECD5.A0717B40 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I used a extended log using example:     

 

http://svn.apache.org/viewvc/logging/log4net/trunk/extension= s/net/1.0/log4ne

t.Ext.EventID/cs/src/EventIDLogImpl.cs?view=3Dco = .

 

 

 

 I have properties InstanceId that is = setted in extended log: 

 

        &nbs= p;   LoggingEvent loggingEvent =3D new

 

        &nbs= p;         LoggingEvent(ThisDeclaringType, Logger.Repository, = Logger.Name,

 

        &nbs= p;            = ;            =             &= nbsp;           &n= bsp;   Level.Info, message, exc);

 

            loggingEvent.Proper= ties["InstanceId"] =3D logData.DCSInstanceId;

 

        &nbs= p;   Logger.Log(loggingEvent);

 

 I received error:

 

      [6108] = log4net:ERROR XmlHierarchyConfigurator: Cannot find Property [conversionPattern] to = set object on [log4net.Appender.AdoNetAppenderParameter]

 

 

 

 Where it is the problem? Do you can help = me? The logs works correctly if uses other appender: = "log4net.Appender.OutputDebugStringAppender"

 

 

 

 

 

I used log4net 1.2.10.0(windows) with following configuration for log4net:

 

 

 

<log4net>

 

    <appender name=3D"AdoNetAppender_SqlServer"

 

type=3D"log4net.Appender.AdoNetAppender"&g= t;

 

    <bufferSize value=3D"100"/>

 

    <connectionType value=3D"System.Data.SqlClient.SqlConnection, System.Data, Version=3D1.0.3300.0, Culture=3Dneutral, = PublicKeyToken=3Db77a5c561934e089" />

 

    <connectionString = value=3D"data source=3DXXX; initial catalog=3DXXX; integrated security=3Dfalse;persist = security info=3DTrue;User ID=3DXXX;Password=3DXXX" />

 

    <commandText value=3D"[Routine].[usp_InsertLog]" />

 

    <commandType value=3D"StoredProcedure" />

 

    = <parameter>

 

        <parameterName value=3D"@log_date" />

 

        = <dbType value=3D"DateTime" />

 

        = <layout type=3D"log4net.Layout.RawTimeStampLayout" = />

 

    = </parameter>

 

    = <parameter>

 

        <parameterName value=3D"@message" />

 

        = <dbType value=3D"String" />

 

        = <size value=3D"4000" />

 

        = <layout type=3D"log4net.Layout.PatternLayout">

 

        <conversionPattern value=3D"%message" />

 

        </layout>

 

    = </parameter>

 

    = <parameter>

 

        &nbs= p; <parameterName value=3D"@instance_id" />

 

        &nbs= p; <dbType value=3D"int32" />

 

        &nbs= p; <layout type=3D"Dcs.Log.ProtocolInfoPatternLayout, Dcs.Log" = />

 

        &nbs= p; <layout = type=3D"log4net.Layout.PatternLayout">

 

        &nbs= p; <conversionPattern value=3D"%P{InstanceId}" = />

 

    = </parameter>

 

</appender>

 

 

 

<root>

 

      <level value=3D"DEBUG" />

 

      <appender-ref ref=3D"DebugView" />

 

      <appender-ref ref=3D"AdoNetAppender_SqlServer" /> </root> = </log4net>

 

 

 

Have a nice day

 

Andy

 

------=_NextPart_000_0037_01C8ECD5.A0717B40--