log4j JDBC appender

[smitha rai]

Hi Gurus,

I am trying to log the error message generated by a java code into the database using log4j. If someone has a sample java code and log4j configuration parameters, appreciate if you could provide the same.

Regards,

Smitha

[Jagadeesh Kumar Macherla]

Please check this url
http://www.dankomannhaupt.de/projects/

[emm raha]

Sample log4j.properties, to log to MS SQL Server using JTDS database driver:

  
log4j.logger.com.yourpackage.yourclass=INFO, db_all
 
log4j.appender.db_all=org.apache.log4j.jdbcplus.JDBCAppender
log4j.appender.db_all.dbclass=net.sourceforge.jtds.jdbc.Driver
log4j.appender.db_all.url=jdbc:jtds:sqlserver://MACHINENAME:1433/DBNAME
log4j.appender.db_all.username=log4jtst
log4j.appender.db_all.password=log4jtst
log4j.appender.db_all.sql=INSERT INTO tbl_log4jtest (Message) VALUES ('@INC@  @PRIO@  @CAT@ @MSG@ @TIMESTAMP@')
log4j.appender.db_all.layout=org.apache.log4j.PatternLayout
log4j.appender.db_all.layout.ConversionPattern=%m

Instantiate and use as usual:

  
Logger logger = Logger.getLogger(YourClass.class);
logger.debug("log this to the db");

[ January 17, 2005: Message edited by: emm raha ]