You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@logging.apache.org by fr...@apache.org on 2025/03/10 19:17:14 UTC
(logging-log4net-site) branch asf-staging updated: updated config examples
This is an automated email from the ASF dual-hosted git repository.
freeandnil pushed a commit to branch asf-staging
in repository https://gitbox.apache.org/repos/asf/logging-log4net-site.git
The following commit(s) were added to refs/heads/asf-staging by this push:
new 4fa1f5f updated config examples
4fa1f5f is described below
commit 4fa1f5f2abe86777904576c8f11b70f7d6be5d5a
Author: Jan Friedrich <fr...@apache.org>
AuthorDate: Mon Mar 10 20:17:02 2025 +0100
updated config examples
---
log4net-3.1.0/development.html | 2 +-
log4net-3.1.0/download.html | 2 +-
log4net-3.1.0/features.html | 2 +-
log4net-3.1.0/index.html | 2 +-
log4net-3.1.0/manual/appenders.html | 2 +-
log4net-3.1.0/manual/configuration-examples.html | 116 +++++++++++++++++++++--
log4net-3.1.0/manual/configuration.html | 2 +-
log4net-3.1.0/manual/filters.html | 2 +-
log4net-3.1.0/manual/index.html | 2 +-
log4net-3.1.0/manual/installation.html | 2 +-
log4net-3.1.0/manual/layouts.html | 2 +-
log4net-3.1.0/release-notes.html | 2 +-
log4net-3.1.0/release-review.html | 2 +-
log4net-3.1.0/sitemap.xml | 26 ++---
14 files changed, 132 insertions(+), 34 deletions(-)
diff --git a/log4net-3.1.0/development.html b/log4net-3.1.0/development.html
index 20e5669..79f3ac4 100644
--- a/log4net-3.1.0/development.html
+++ b/log4net-3.1.0/development.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="manual/configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="manual/configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="manual/configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/download.html b/log4net-3.1.0/download.html
index d3f6425..51b24bb 100644
--- a/log4net-3.1.0/download.html
+++ b/log4net-3.1.0/download.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="manual/configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="manual/configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="manual/configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/features.html b/log4net-3.1.0/features.html
index bfb5929..b730cf3 100644
--- a/log4net-3.1.0/features.html
+++ b/log4net-3.1.0/features.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="manual/configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="manual/configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="manual/configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/index.html b/log4net-3.1.0/index.html
index d7884f7..e359d8f 100644
--- a/log4net-3.1.0/index.html
+++ b/log4net-3.1.0/index.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="manual/configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="manual/configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="manual/configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/manual/appenders.html b/log4net-3.1.0/manual/appenders.html
index 264d1cd..4fc6024 100644
--- a/log4net-3.1.0/manual/appenders.html
+++ b/log4net-3.1.0/manual/appenders.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/manual/configuration-examples.html b/log4net-3.1.0/manual/configuration-examples.html
index f504f1f..60d10d9 100644
--- a/log4net-3.1.0/manual/configuration-examples.html
+++ b/log4net-3.1.0/manual/configuration-examples.html
@@ -3,7 +3,7 @@
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
- <title>Config Examples :: Apache log4net</title>
+ <title>Configuration Examples :: Apache log4net</title>
<link rel="canonical" href="https://logging.apache.org/log4net/manual/configuration-examples.html">
<meta name="generator" content="Antora 3.2.0-alpha.6">
<link rel="stylesheet" href="../_/css/site.css">
@@ -82,7 +82,7 @@
<a class="nav-link" href="configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item is-current-page" data-depth="3">
- <a class="nav-link" href="configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
@@ -126,7 +126,7 @@
<li><a href="../index.html">Home</a></li>
<li><a href="index.html">Manual</a></li>
<li><a href="configuration.html">Configuration</a></li>
- <li><a href="configuration-examples.html">Config Examples</a></li>
+ <li><a href="configuration-examples.html">Configuration Examples</a></li>
</ul>
</nav>
<div class="edit-this-page"><a href="https://github.com/apache/logging-log4net/edit/Feature/Antora/src/site/antora/modules/ROOT/pages/manual/configuration-examples.adoc">Edit this Page</a></div>
@@ -136,7 +136,7 @@
<div class="toc-menu"></div>
</aside>
<article class="doc">
-<h1 class="page">Config Examples</h1>
+<h1 class="page">Configuration Examples</h1>
<div id="preamble">
<div class="sectionbody">
<div class="paragraph">
@@ -151,13 +151,18 @@
<h2 id="adonetappender"><a class="anchor" href="#adonetappender"></a>AdoNetAppender</h2>
<div class="sectionbody">
<div class="paragraph">
-<p>The configuration of the AdoNetAppender depends on the provider selected for the target database. Here are some examples.</p>
+<p>The configuration of the AdoNetAppender depends on the provider selected for the target database.</p>
</div>
-<div class="sect2">
-<h3 id="mssqlserver"><a class="anchor" href="#mssqlserver"></a>MS SQL Server</h3>
<div class="paragraph">
-<p>The following example shows how to configure the AdoNetAppender to log messages to a SQL Server database. The events are written in batches of 100 (BufferSize). The ConnectionType specifies the fully qualified type name for the System.Data.IDbConnection to use to connect to the database. The ConnectionString is database provider specific. The CommandText is either a prepared statement or a stored procedure, in this case it is a prepared statement. Each parameter to the prepared statem [...]
+<p>The following examples show how to configure the AdoNetAppender to log messages to different databases.
+The events are written in batches of 100 (BufferSize).
+The ConnectionType specifies the fully qualified type name for the System.Data.IDbConnection to use to connect to the database.
+The ConnectionString is database provider specific.
+The CommandText is either a prepared statement or a stored procedure, in this case it is a prepared statement.
+Each parameter to the prepared statement or stored procedure is specified with its name, database type and a layout that renders the value for the parameter.</p>
</div>
+<div class="sect2">
+<h3 id="mssqlserver"><a class="anchor" href="#mssqlserver"></a>MS SQL Server</h3>
<div class="paragraph">
<p>The database table definition is:</p>
</div>
@@ -177,13 +182,21 @@
</div>
</div>
<div class="paragraph">
+<p>Please add a package reference for the SqlClient to your .csproj file</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="highlightjs highlight"><code class="language-xml hljs" data-lang="xml"> <PackageReference Include="Microsoft.Data.SqlClient" Version="*" /></code></pre>
+</div>
+</div>
+<div class="paragraph">
<p>The appender configuration is:</p>
</div>
<div class="listingblock">
<div class="content">
<pre class="highlightjs highlight"><code class="language-xml hljs" data-lang="xml"><appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
<bufferSize value="100"/>
- <connectionType value="System.Data.SqlClient.SqlConnection, System.Data"/>
+ <connectionType value="Microsoft.Data.SqlClient.SqlConnection, Microsoft.Data.SqlClient"/>
<connectionString value="data source=[database server];initial catalog=[database name];integrated security=false;persist security info=True;User ID=[user];Password=[password]"/>
<commandText value="insert into dbo.Log (LogDate, Thread, LogLevel, Logger, LogMessage, Exception) values (@LogDate, @Thread, @LogLevel, @Logger, @LogMessage, @Exception)"/>
<parameter>
@@ -233,6 +246,91 @@
</div>
</div>
</div>
+<div class="sect2">
+<h3 id="oracle"><a class="anchor" href="#oracle"></a>Oracle</h3>
+<div class="paragraph">
+<p>Please add a package reference for the SqlClient to your .csproj file</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="highlightjs highlight"><code class="language-xml hljs" data-lang="xml"> <PackageReference Include="Oracle.ManagedDataAccess.Core" Version="*" /></code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>The database table definition is:</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="highlightjs highlight"><code class="language-sql hljs" data-lang="sql">create table Log
+(
+ Id number(10) generated by default as identity,
+ LogDate date not null,
+ Thread varchar2(255) not null,
+ LogLevel varchar2(50) not null,
+ Logger varchar2(255) not null,
+ LogMessage varchar2(2000) not null,
+ Exception varchar2(2000) null,
+ constraint Log_PKEY primary key (Id)
+)</code></pre>
+</div>
+</div>
+<div class="paragraph">
+<p>The appender configuration is:</p>
+</div>
+<div class="listingblock">
+<div class="content">
+<pre class="highlightjs highlight"><code class="language-xml hljs" data-lang="xml"><appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
+ <bufferSize value="100"/>
+ <connectionType value="Oracle.ManagedDataAccess.Client.OracleConnection, Oracle.ManagedDataAccess.Client"/>
+ <connectionString value="data source=[mydatabase];User ID=[user];Password=[password]"/>
+ <commandText value="insert into dbo.Log (LogDate, Thread, LogLevel, Logger, LogMessage, Exception) values (@LogDate, @Thread, @LogLevel, @Logger, @LogMessage, @Exception)"/>
+ <parameter>
+ <parameterName value="@LogDate"/>
+ <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="@LogLevel"/>
+ <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="@LogMessage"/>
+ <dbType value="String"/>
+ <size value="2000"/>
+ <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></pre>
+</div>
+</div>
+</div>
</div>
</div>
</article>
diff --git a/log4net-3.1.0/manual/configuration.html b/log4net-3.1.0/manual/configuration.html
index 7e5577f..cf46a30 100644
--- a/log4net-3.1.0/manual/configuration.html
+++ b/log4net-3.1.0/manual/configuration.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/manual/filters.html b/log4net-3.1.0/manual/filters.html
index 5b7f060..bbee752 100644
--- a/log4net-3.1.0/manual/filters.html
+++ b/log4net-3.1.0/manual/filters.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/manual/index.html b/log4net-3.1.0/manual/index.html
index 449f75d..3135d2d 100644
--- a/log4net-3.1.0/manual/index.html
+++ b/log4net-3.1.0/manual/index.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/manual/installation.html b/log4net-3.1.0/manual/installation.html
index 6963c96..ddaf03a 100644
--- a/log4net-3.1.0/manual/installation.html
+++ b/log4net-3.1.0/manual/installation.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/manual/layouts.html b/log4net-3.1.0/manual/layouts.html
index 11b22a6..09d522d 100644
--- a/log4net-3.1.0/manual/layouts.html
+++ b/log4net-3.1.0/manual/layouts.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/release-notes.html b/log4net-3.1.0/release-notes.html
index ea2d73a..b69965a 100644
--- a/log4net-3.1.0/release-notes.html
+++ b/log4net-3.1.0/release-notes.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="manual/configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="manual/configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="manual/configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/release-review.html b/log4net-3.1.0/release-review.html
index 7a9655a..6613746 100644
--- a/log4net-3.1.0/release-review.html
+++ b/log4net-3.1.0/release-review.html
@@ -82,7 +82,7 @@
<a class="nav-link" href="manual/configuration.html">Configuration</a>
<ul class="nav-list">
<li class="nav-item" data-depth="3">
- <a class="nav-link" href="manual/configuration-examples.html">Config Examples</a>
+ <a class="nav-link" href="manual/configuration-examples.html">Configuration Examples</a>
</li>
</ul>
</li>
diff --git a/log4net-3.1.0/sitemap.xml b/log4net-3.1.0/sitemap.xml
index 651809c..5e374f8 100644
--- a/log4net-3.1.0/sitemap.xml
+++ b/log4net-3.1.0/sitemap.xml
@@ -2,54 +2,54 @@
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<url>
<loc>https://logging.apache.org/log4net/development.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/download.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/features.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/index.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/manual/appenders.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/manual/configuration-examples.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/manual/configuration.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/manual/filters.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/manual/index.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/manual/installation.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/manual/layouts.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/release-notes.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
<url>
<loc>https://logging.apache.org/log4net/release-review.html</loc>
-<lastmod>2025-03-05T17:59:08.628Z</lastmod>
+<lastmod>2025-03-10T19:07:36.061Z</lastmod>
</url>
</urlset>