Hi Heri,
I would be vey interested to know how you configured all that. Also, is
there no performance hit with all that logging from java to the db?
Rakesh
Bender Heri wrote:
I dont use log4plsql, but I have a System which logs by a JDBC-Appender to a
Oracle-Table, and the stored
The DB Appender is self written and configured as follows:
appender name=DB_APPENDER
class=ch.ergonomics.pms.common.supervision.PMSJDBCAppender
param name=PreparedSQL value={ ? = call INS_LOG( ?, ?, ?, ?, ?, ? )
}/
layout class=org.apache.log4j.PatternLayout
Thank you, what about performance?
Bender Heri wrote:
The DB Appender is self written and configured as follows:
appender name=DB_APPENDER
class=ch.ergonomics.pms.common.supervision.PMSJDBCAppender
param name=PreparedSQL value={ ? = call INS_LOG( ?, ?, ?, ?, ?, ? )
}/
I have not noticed a performance impact, since we log only WARN, ERROR, and
FATAL into DB. And this occurs not that often.
Heri
-Original Message-
From: Rakesh Patel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 08, 2006 2:50 PM
To: Log4J Users List
Subject: Re: Using the same
The fact that you write to a DB will always make the process slower (than
writting to a file) per se.
Now many elements should be considered (DB has huge memory, multi process, IO's
in C/C++ versus pure Java) to confirm this but I can afford a small performance
impact to gain system wide