Return-Path: 
 <log4net-user-return-1030-apmail-logging-log4net-user-archive=logging.apache.org@logging.apache.org>
Delivered-To: apmail-logging-log4net-user-archive@www.apache.org
Received: (qmail 16858 invoked from network); 15 Dec 2004 22:18:40 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur-2.apache.org with SMTP; 15 Dec 2004 22:18:40 -0000
Received: (qmail 69497 invoked by uid 500); 15 Dec 2004 22:18:39 -0000
Delivered-To: apmail-logging-log4net-user-archive@logging.apache.org
Received: (qmail 69478 invoked by uid 500); 15 Dec 2004 22:18:39 -0000
Mailing-List: contact log4net-user-help@logging.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:log4net-user-help@logging.apache.org>
list-unsubscribe: <mailto:log4net-user-unsubscribe@logging.apache.org>
list-post: <mailto:log4net-user@logging.apache.org>
Reply-To: "Log4NET User" <log4net-user@logging.apache.org>
Delivered-To: mailing list log4net-user@logging.apache.org
Received: (qmail 69464 invoked by uid 99); 15 Dec 2004 22:18:38 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of nicko@neoworks.com designates
 80.168.17.114 as permitted sender)
Received: from Unknown (HELO kronos.neoworks.co.uk) (80.168.17.114)
  by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 15 Dec 2004 14:16:49 -0800
X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: logging to DB2
Date: Wed, 15 Dec 2004 22:17:59 -0000
Message-ID: <DDEB64C8619AC64DBC074208B046611C59C78A@kronos.neoworks.co.uk>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: logging to DB2
Thread-Index: AcTi7qjid6J8vxBxSGasRHQzP0HFTAABQOKQ
From: "Nicko Cadell" <nicko@neoworks.com>
To: "Log4NET User" <log4net-user@logging.apache.org>
X-Virus-Checked: Checked
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Thanks.=20

> -----Original Message-----
> From: M. d'Entremont [mailto:mdent@crm3.com]=20
> Sent: 15 December 2004 20:40
> To: Log4NET User
> Subject: Re: logging to DB2
>=20
> DB2 8.2, a.k.a Stinger
>=20
> It's their most recent to date. Pretty much every thing=20
> should be similar on old versions with slight syntactic changes
>=20
> Marc
>=20
> Nicko Cadell wrote:=20
>=20
> 	Marc,
> =09
> 	Thanks for the schema and config.
> 	Can you tell me which version of db2 you have this working on?=20
> =09
> 	Many thanks,
> 	Nicko
> =09
> 	 =20
>=20
> 		-----Original Message-----
> 		From: M. d'Entremont [mailto:mdent@crm3.com]=20
> 		Sent: 11 December 2004 01:12
> 		To: Log4NET User
> 		Subject: logging to DB2
> 	=09
> 		I've got log4net logging to db2. I thought this=20
> could be=20
> 		helpful to someone.
> 	=09
> 		Note: The level field was slightly problematic=20
> as it was=20
> 		initially 50 varchars, but log4net seems to=20
> send the whole=20
> 		string even when larger then 50. It therefore=20
> produced a=20
> 		right truncation error.
> 		Beyond that the table create, connectionType and=20
> 		connectionString where the only changes
> 	=09
> 		Thanks
> 		It's a great project
> 		Marc
> 	=09
> 		CREATE TABLE "myschema.LOG"  (
> 		          "ID" INTEGER NOT NULL   GENERATED=20
> ALWAYS AS IDENTITY ( =20
> 		            START WITH +1 =20
> 		            INCREMENT BY +1 =20
> 		            MINVALUE +1 =20
> 		            MAXVALUE +2147483647 =20
> 		            NO CYCLE =20
> 		            NO CACHE =20
> 		            NO ORDER ) ,=20
> 		          "DATE" TIMESTAMP NOT NULL ,=20
> 		          "THREAD" VARCHAR(255) NOT NULL,=20
> 		          "LEVEL" VARCHAR(500) NOT NULL,=20
> 		          "LOGGER" VARCHAR(255) NOT NULL,=20
> 		          "MESSAGE" VARCHAR(4000) NOT NULL,=20
> 		          "EXCEPTION" VARCHAR(2000) )  =20
> 		         IN "LRGTABLES" ;        =20
> 		        =20
> 		        =20
> 		<?xml version=3D"1.0" encoding=3D"utf-8" ?>
> 		<configuration>
> 		  <configSections>
> 		    <section name=3D"log4net"=20
> 		     =20
> type=3D"log4net.Config.Log4NetConfigurationSectionHandler,
> 		            log4net-net-1.0"=20
> 		    />
> 		  </configSections>
> 	=09
> 		  <log4net>
> 		   =20
> 		    <logger name=3D"collectEmail">
> 		      <level value=3D"DEBUG"/>
> 		    </logger>
> 		   =20
> 		    <root>
> 		      <level value=3D"DEBUG" />
> 		      <appender-ref ref=3D"LogFileAppender" />
> 		      <appender-ref ref=3D"ConsoleAppender" />
> 		       <appender-ref ref=3D"ADONetAppender" />
> 		    </root>
> 		   =20
> 		    <appender name=3D"LogFileAppender"=20
> 		             type=3D"log4net.Appender.FileAppender" >
> 		      <param name=3D"File" value=3D"c:\\log-file.txt" />
> 		      <param name=3D"AppendToFile" value=3D"true" />
> 		      <layout type=3D"log4net.Layout.PatternLayout">
> 		        <param name=3D"Header" value=3D"[Header]\r\n"/>
> 		        <param name=3D"Footer" value=3D"[Footer]\r\n"/>
> 		        <param name=3D"ConversionPattern"=20
> 		           value=3D"%d [%t] %-5p %c [%x]  - %m%n"
> 		         />
> 		      </layout>
> 		      <!--
> 		      <filter type=3D"log4net.Filter.LevelRangeFilter">
> 		        <param name=3D"LevelMin" value=3D"DEBUG" />
> 		        <param name=3D"LevelMax" value=3D"WARN" />
> 		      </filter>    -->
> 		    </appender>
> 	=09
> 		    <appender name=3D"ConsoleAppender"=20
> 		              type=3D"log4net.Appender.ConsoleAppender" >
> 		      <layout type=3D"log4net.Layout.PatternLayout">
> 		        <param name=3D"ConversionPattern"=20
> 		           value=3D"%d [%t] %-5p %c [%x]  - %m%n"=20
> 		        />
> 		      </layout>
> 		    </appender>
> 		   =20
> 		    <appender name=3D"ADONetAppender"=20
> 		type=3D"log4net.Appender.ADONetAppender">
> 		    <bufferSize value=3D"1" />
> 		    <connectionType=20
> 		value=3D"IBM.Data.DB2.DB2Connection,IBM.Data.DB2,=20
> Version=3D8.1.2.1" />
> 		    <connectionString=20
> 		value=3D"server=3D192.168.0.0;database=3Ddbuser;user=20
> 		Id=3Dusername;password=3Dpassword;persist security=20
> info=3Dtrue" />
> 		    <commandText value=3D"INSERT INTO CNTMGR.Log=20
> 		(Date,Thread,Level,Logger,Message,Exception) VALUES=20
> 		(@log_date, @thread, @log_level, @logger,=20
> @message, @exception)" />
> 		    <parameter>
> 		        <parameterName value=3D"@log_date" />
> 		        <dbType value=3D"DateTime" />
> 		        <layout=20
> type=3D"log4net.Layout.RawTimeStampLayout" />
> 		    </parameter>
> 		    <parameter>
> 		        <parameterName value=3D"@thread" />
> 		        <dbType value=3D"String" />
> 		        <size value=3D"255" />
> 		        <layout type=3D"log4net.Layout.PatternLayout">
> 		            <conversionPattern value=3D"%thread" />
> 		        </layout>
> 		    </parameter>
> 		    <parameter>
> 		        <parameterName value=3D"@log_level" />
> 		        <dbType value=3D"String" />
> 		        <size value=3D"500" />
> 		        <layout type=3D"log4net.Layout.PatternLayout">
> 		            <conversionPattern value=3D"%level" />
> 		        </layout>
> 		    </parameter>
> 		    <parameter>
> 		        <parameterName value=3D"@logger" />
> 		        <dbType value=3D"String" />
> 		        <size value=3D"255" />
> 		        <layout type=3D"log4net.Layout.PatternLayout">
> 		            <conversionPattern value=3D"%logger" />
> 		        </layout>
> 		    </parameter>
> 		    <parameter>
> 		        <parameterName value=3D"@message" />
> 		        <dbType value=3D"String" />
> 		        <size value=3D"4000" />
> 		        <layout type=3D"log4net.Layout.PatternLayout">
> 		            <conversionPattern value=3D"%m" />
> 		        </layout>
> 		    </parameter>
> 		    <parameter>
> 		        <parameterName value=3D"@exception" />
> 		        <dbType value=3D"String" />
> 		        <size value=3D"2000" />
> 		        <layout type=3D"log4net.Layout.ExceptionLayout" />
> 		    </parameter>
> 		</appender>
> 		   =20
> 		  </log4net>
> 		</configuration>
> 	=09
> 	=09
> 		 =20
> 	=09
> 	=09
> 		.
> 	=09
> 	=09
> 		   =20
>=20
>=20
> --=20
>=20
> Marc d'Entremont	 Ph: (250) 386-4266	=20
> Convergent Media Network	 Fax: (250) 386-4267	=20
> 210-19 Dallas Rd.	 Mobile: (250) 886-8665	=20
> Victoria, BC	 mdent@crm3.com	=20
> V8V 5A6	=20
>=20
>=20
>          =20
>=20
> This electronic message transmission, including any attached=20
> files, contains information which may be confidential and/or=20
> privileged. The information is intended to be for the SOLE=20
> use of the individual or entity named above. If you are not=20
> the intended recipient, be aware that any review, disclosure,=20
> copying, distribution or use of the contents of this=20
> information is prohibited.  This message is not to be=20
> forwarded for any reason without prior consent of the sender.
>=20
> If you have received this electronic transmission in error,=20
> please notify the sender immediately by telephone (250)=20
> 386-4266 or by a "reply to sender only" message and destroy=20
> all electronic and hard copies of the communication,=20
> including attachments, without reading or saving in any manner.
>=20
>=20