Re: Using the same tables for log4j with JDBC appender and Log4PLSQL

2006-03-08 Thread Rakesh Patel
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

RE: Using the same tables for log4j with JDBC appender and Log4PLSQL

2006-03-08 Thread Bender Heri
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

Re: Using the same tables for log4j with JDBC appender and Log4PLSQL

2006-03-08 Thread Rakesh Patel
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( ?, ?, ?, ?, ?, ? ) }/

RE: Using the same tables for log4j with JDBC appender and Log4PLSQL

2006-03-08 Thread Bender Heri
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

Re: Using the same tables for log4j with JDBC appender and Log4PLSQL

2006-03-08 Thread duvelbier-tsmets
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