RE: Log4Net for Oracle 8i

[Bala Nagarajan]

<log4net debug="true">
    <appender name="ADONetAppender_Oracle"
type="log4net.Appender.ADONetAppender"
assembly="log4net,Version=1.2.9.0,Culture=neutral,PublicKeyToken=b32731d11ce
58905">
Franson,
         It took a while for me to configure log4net to write into oracle.
The example given in the web site does not work. Try using the following
configuration section for log4net by replacing your values. Let me know if
it helps.


Thanks 


Bala



      <param name="ConnectionType"
value="System.Data.OracleClient.OracleConnection,
System.Data.OracleClient,Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089" />
      <param name="ConnectionString" value="Data Source=[datasource];User
Id=[userid];Password=[pwd];" />
      
      <param name="CommandType" value="StoredProcedure" />
      <param name="CommandText" value="AMOLogging.LogMessage" />
      <param name="bufferSize" value="1" />
      <param name="Parameter">
        <param name="ParameterName" value="log_level" />
        <param name="Layout" type="log4net.Layout.PatternLayout">
          <param name="ConversionPattern" value="%p" />
        </param>
      </param>
      <param name="Parameter">
        <param name="ParameterName" value="logger" />
        <param name="DbType" value="string" />
        <param name="Layout" type="log4net.Layout.PatternLayout">
          <param name="ConversionPattern" value="%c" />
        </param>
      </param>
      <param name="Parameter">
        <param name="ParameterName" value="message" />
        <param name="DbType" value="string" />
        <param name="Layout" type="log4net.Layout.PatternLayout">
          <param name="ConversionPattern" value="%m" />
        </param>
      </param>
      <param name="Parameter">
        <param name="ParameterName" value="exception_message" />
        <param name="size" value="4000" />
        <param name="Layout" type="log4net.Layout.ExceptionLayout">
        </param>
      </param>
    </appender>
    <root>
      <appender-ref ref="ADONetAppender_Oracle" />
      <level value="debug" />
    </root>
  </log4net>
  

-----Original Message-----
From: clady franson [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 07, 2005 11:55 PM
To: log4net-user@logging.apache.org
Subject: Log4Net for Oracle 8i

Hi All,

I am franson. I am new to Log4Net for error log. I
want log my error in oracle 8i. I got some example
from the following url.

http://logging.apache.org/log4net/release/config-examples.html#adonetappende
r-o8


I did not get any error message from example. And same
time I cannot insert my error into the database.

Please help me to insert error message into oracle 8i
database. 

Thanks & regards,
Franson




                
__________________________________________________________ 
Enjoy this Diwali with Y! India Click here
http://in.promos.yahoo.com/fabmall/index.html