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 clady franson <fr...@yahoo.co.in> on 2005/11/08 06:55:16 UTC

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#adonetappender-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

Re: Log4Net for Oracle 8.1.7

Posted by clady franson <fr...@yahoo.co.in>.
Hi All,


I am franson. I try to insert error into my
oracle8.1.7 database. I cannot get any error message.
And I cannot insert the error messeage to database.

please help me to insert my message to Oracle 8i
database through Log4net.

what are the think we need to insert my message to
oracle 8i database?

I am using System.Data.OracleClient in my web based
application. 

which oracle version is support by Log4net?

I need some example.

Thanks

Franson.I



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

RE: Log4Net for Oracle 8i

Posted by Bala Nagarajan <c-...@mci.com>.
<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:fransonmca@yahoo.co.in] 
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