Logging to Oracle -- still looking for help

[pa...@firstenergycorp.com]

Hello again,

I'm still looking for any assistance I can get with this problem. Wasn't
sure if the lack of response was due to the fact that nobody else has done
this or something that I did in my post (too much information in post?  Not
formatted right?)

If there is ANYTHING else I can provide please let me know. I'd really like
to figure out how to get this to work. There doesn't seem to be any other
resources besides this mailing list when it comes to log4net. If there are
I'd really appreciate it if anyone could point me to them.

Thanks in advance!

David

--------------    original message ---------------

Hello,

I getting stuck trying to get this Oracle logging example to work ... (
http://log4net.sourceforge.net/release/1.2.0.30507/doc/manual/example-config-appender.html
)  We don't have Oracle 9. The only thing I thought I had to do was to
eliminate the Datetime column because our version of Oracle doesn't have a
datatype of timestamp.

So my table is defined as follows:

CREATE TABLE CSAX30.LOG
(
      THREAD      VARCHAR2(255),
      LOG_LEVEL   VARCHAR2(255),
      LOGGER      VARCHAR2(255),
      MESSAGE     VARCHAR2(4000)
)
TABLESPACE CSAX30D LOGGING

The Web.config file section for this appender looks like this:

      <appender name="ADONetAppender_Oracle" type
="log4net.Appender.ADONetAppender" >
            <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=oragen1d;User
ID=csax30;Password=oragen1d" />
            <param name="CommandText" value="INSERT INTO Log
(Thread,Log_Level,Logger,Message) VALUES (:log_date, :thread, :log_level,
:logger, :message)" />
            <param name="BufferSize" value="128" />
            <param name="Parameter">
                  <param name="ParameterName" value=":thread" />
                  <param name="DbType" value="String" />
                  <param name="Size" value="255" />
                  <param name="Layout" type="log4net.Layout.PatternLayout">
                        <param name="ConversionPattern" value="%t" />
                  </param>
            </param>
            <param name="Parameter">
                  <param name="ParameterName" value=":log_level" />
                  <param name="DbType" value="String" />
                  <param name="Size" value="50" />
                  <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="Size" value="255" />
                  <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="Size" value="4000" />
                  <param name="Layout" type="log4net.Layout.PatternLayout">
                        <param name="ConversionPattern" value="%m" />
                  </param>
            </param>
      </appender>

And in my code I do this...
          Private Shared ReadOnly oraclelog As ILog =
LogManager.GetLogger("ADONetAppender_Oracle")
           ...
          If oraclelog.IsDebugEnabled Then oraclelog.Debug("oracle
message")


I've stepped thru the code in debugger and the "oraclelog.IsDebugEnabled"
method returns True. I've enclosed the above statement in a try/catch
thinking that maybe there was an error but there was none.

I'm sure I'm missing something very simple but I can't figure out what.

Has anyone been successful in logging to Oracle? If so, can you tell what
I'm doing wrong?

Thanks in advance for any help.

David.




-----------------------------------------
The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.