You are viewing a plain text version of this content. The canonical link for it is here.
Posted to log4net-user@logging.apache.org by jo...@bankone.com on 2005/06/14 19:50:59 UTC
issue with AdoNetAdapter
First let me give some background info, then I will describe my issue...
1. VS.NET 2003
2. .NET runtime 1.1
3. Log4Net version 1.2.9
4. Windows Form application. uses log4net.dll debug version.
5. Connecting to Oracle 9i database
I am trying to set up log4net to log to an AdoNetAppender for Oracle 9i.
When I went to test, I could
not get any log messages to write to the database. I verified that the
output from the logger
initialization was not throwing any log4net errors. So to ensure that I
was connecting ok to the database,
I put in a simple call to the same database I am trying to log messages to
(i.e. con.Open(), cmd.Execute, con.Close()). To my surprise, once I added
this call,
the logging worked, even if I close the connection before logging a
message. But when I comment out
again, the logging stopped working again. So it almost looks to me like it
needs me to open a
connection to the database before I ever start logging to it, even though
the connection string
for the log4net configuration is different than the one used for the
simple sql test. Shouldn't
the AdoNetAppender open the connection using it's settings up front...or
am I missing something
in the documentation? I included my App.config log4net configuration
section below...
<configSections>
<section name="log4net"
type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
</configSections>
<log4net>
<appender name="OracleAppender" type="log4net.Appender.AdoNetAppender">
<connectionType value="System.Data.OracleClient.OracleConnection,
System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089" />
<connectionString value="left out, but a valid connection string being
used elsewhere" />
<commandText value="insert into SOME_LOG
(LOG_DATE,LOG_LEVEL,LOG_MESSAGE,LOG_EXCEPTION) VALUES
(:log_date,:log_level,:message,:exception)" />
<bufferSize value="128" />
<parameter>
<parameterName value=":log_date" />
<dbType value="DateTime" />
<layout type="log4net.Layout.RawTimeStampLayout" />
</parameter>
<parameter>
<parameterName value=":log_level" />
<dbType value="String" />
<size value="25" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%level" />
</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="4000" />
<layout type="log4net.Layout.ExceptionLayout" />
</parameter>
</appender>
<root>
<level value="INFO" />
<appender-ref ref="OracleAppender" />
</root>
</log4net>
This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.