You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4net-dev@logging.apache.org by ni...@apache.org on 2004/07/31 16:45:23 UTC
cvs commit: logging-log4net/xdocs/src/release config-examples.xml
nicko 2004/07/31 07:45:23
Modified: xdocs/src/release config-examples.xml
Log:
added oracle8i example adonet appender config
Revision Changes Path
1.2 +52 -0 logging-log4net/xdocs/src/release/config-examples.xml
Index: config-examples.xml
===================================================================
RCS file: /home/cvs/logging-log4net/xdocs/src/release/config-examples.xml,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- config-examples.xml 13 Feb 2004 19:04:19 -0000 1.1
+++ config-examples.xml 31 Jul 2004 14:45:23 -0000 1.2
@@ -246,7 +246,59 @@
</appender>
]]></source>
</section>
+
+ <section name="Oracle8i">
+ <p>
+ This example shows how to write events to an Oracle8i Database.
+ </p>
+ <p>
+ The database table definition is:
+ </p>
+ <source language="sql"><![CDATA[
+CREATE TABLE CSAX30.LOG
+(
+ THREAD VARCHAR2(255),
+ LOG_LEVEL VARCHAR2(255),
+ LOGGER VARCHAR2(255),
+ MESSAGE VARCHAR2(4000)
+)
+TABLESPACE CSAX30D LOGGING
+ ]]></source>
+ <p>
+ The appender configuration is:
+ </p>
+ <source language="xml"><![CDATA[
+<appender name="ADONetAppender_Oracle" type="log4net.Appender.ADONetAppender">
+ <connectionType value ="System.Data.OracleClient.OracleConnection, System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
+ <connectionString value="data source=<dsname>;User ID=<userid>;Password=<password>" />
+ <commandText value="INSERT INTO Log (Log_Level,Logger,Message) VALUES (:log_level, :logger, :message)" />
+ <bufferSize value="250" />
+ <parameter>
+ <parameterName value=":log_level" />
+ <layout type="log4net.Layout.PatternLayout">
+ <conversionPattern value="%p" />
+ </layout>
+ </parameter>
+ <parameter>
+ <parameterName value=":logger" />
+ <layout type="log4net.Layout.PatternLayout">
+ <conversionPattern value="%c" />
+ </layout>
+ </parameter>
+ <parameter>
+ <parameterName value=":message" />
+ <dbType value="String" />
+ <layout type="log4net.Layout.PatternLayout">
+ <conversionPattern value="%m" />
+ </layout>
+ </parameter>
+</appender>
+ ]]></source>
+ </section>
</section>
+
+
+
<section name="ASPNetTraceAppender">
<p>