Thanks for your help. Logging to Oracle is working now. My connection string for oracle was incorrect.

 

Usman

 

-----Original Message-----
From: Ron Grabowski [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 28, 2005 10:14 AM
To: Log4NET User
Subject: Re: FW: LOG4NET - Oracle 9i logging error

 

I'm a Sql Server guy :-)

 

Instead of copying and pasting a large amount of unfamiliar code and

wondering why it isn't working, have you considered starting out with

simpler code:

 

<appender name="AdoNetAppender_Oracle"

type="log4net.Appender.AdoNetAppender">

 <connectionType value="System.Data.OracleClient.OracleConnection.../>

 <connectionString value="..." />

 <commandText value="INSERT INTO SF_log (Message) VALUES (:message)" />

 <bufferSize value="1" />

 <parameter>

  <parameterName value=":message" />

  <dbType value="String" />

  <size value="4000" />

  <layout type="log4net.Layout.PatternLayout">

   <conversionPattern value="%message" />

  </layout>

 </parameter>

</appender>

 

and gradually adding things until something breaks? If you have a watch

on your log4net.config file, you can gradually add new elements to the

appender without having to re-start your application. The code on the

web page has been the same for several months. It should work. If it

doesn't, it needs to be changed.


Reply via email to