Hi,

I am trying write the Log4Net logs to Oracle.
I'm not too sure what I am doing wrong, I don't get any errors.

Here is the ddl for the Oracle table.
CREATE TABLE log4net
(log_id NUMBER NOT NULL,
log_date DATE,
log_level VARCHAR2(10),
log_identity VARCHAR2(100),
log_message VARCHAR2(4000),
log_exception VARCHAR2(4000))

Here is my web.config:
<configSections>
<section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler,NHibernate" />
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
</configSections>

<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
<bufferSize value="1" />
<connectionType value="Oracle.DataAccess.Client.OracleConnection, Oracle.DataAccess, Version=10.2.0.100, Culture=neutral, PublicKeyToken=89b483f429c47342" />
<commandText value="INSERT INTO LOG4NET (LOG_ID, LOG_DATE, LOG_LEVEL, LOG_IDENTITY, LOG_MESSAGE, LOG_EXCEPTION) VALUES (LOG4NET_SEQ.nextval, :log_date, :log_level, :log_identity, :log_message, :log_exception)" />
<connectionString value="Data Source=na;User ID=na;Password=na;"/>
<parameter>
<parameterName value=":log_date" />
<dbType value="DateTime" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%d{dd/MM/yyyy HH:mm:ss}" />
</layout>
</parameter>
<parameter>
<parameterName value=":log_level" />
<dbType value="String" />
<size value="10" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%level" />
</layout>
</parameter>
<parameter>
<parameterName value=":log_identity" />
<dbType value="String" />
<size value="100" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%identity" />
</layout>
</parameter>
<parameter>
<parameterName value=":log_message" />
<dbType value="String" />
<size value="4000" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%m" />
</layout>
</parameter>
<parameter>
<parameterName value=":log_exception" />
<dbType value="String" />
<size value="4000" />
<layout type="log4net.Layout.PatternLayout">
<conversionPattern value="%exception" />
</layout>
</parameter>
</appender>
<root>
<level value="All"/>
<appender-ref ref="AdoNetAppender_Oracle"/>
</root>
</log4net>


Here is my webpage I do the following:
log4net.Config.XmlConfigurator.Configure()
log4net.Util.LogLog.Error("dsfasdf")


Nothing get logged in the Oracle table, any help would be appreciated.

Roger

Ok,

I finally figured this out.

You must use the database owner in the insert statement.
Before:
<commandText value="INSERT INTO LOG4NET (LOG_ID, LOG_DATE, LOG_LEVEL, LOG_IDENTITY, LOG_MESSAGE, LOG_EXCEPTION)
After:
<commandText value="INSERT INTO DB_OWNER.LOG4NET (LOG_ID, LOG_DATE, LOG_LEVEL, LOG_IDENTITY, LOG_MESSAGE, LOG_EXCEPTION)

Also you might have to change the date format for the log date.
I had to use <conversionPattern value="%d{dd-MMM-yyyy HH:mm:ss}" />