logging-log4j-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frank Burns" <frankbu...@the-hub.demon.co.uk>
Subject JDBCAppender: WHat am I doing wrong?
Date Sat, 05 Jun 2004 23:24:06 GMT
Can anyone please tell me what am I doing wrong?

I'm trying to set up the JDBCAppender but don't get anything logged to the
database. I can't figure out what's wrong. I've even got Ceki's manual, but
it's not covered.

Here's part of my config file:
==============================

##### For sysadmin.databaselogging, assign a logging level of INFO and add a
JDBCAppender to it #####
log4j.logger.sysadmin.databaselogging = INFO, R5

# JDBC appender
log4j.appender.R5=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.R5.BufferSize=4096
log4j.appender.R5.Driver=com.mysql.jdbc.Driver
log4j.appender.R5.URL=jdbc:mysql://localhost/mydb
log4j.appender.R5.user=frank
log4j.appender.R5.password=banana
log4j.appender.R5.layout=org.apache.log4j.PatternLayout
log4j.appender.R5.layout.ConversionPattern=INSERT INTO Logs (Date, Logger,
Priority, Message) VALUES ('%d', '%c', '%p', '%m')
log4j.appender.R5.threshold=INFO

Here's the mySQL database table:
================================

CREATE TABLE Logs(
 Date VARCHAR(255),
 Logger VARCHAR(255),
 Priority VARCHAR(255),
 Message TEXT
 )
 TYPE = InnoDB;

Here's relevant bits of code:
=============================
 ...
 static Logger databaseLogger =
Logger.getLogger("sysadmin.databaselogging");
 ...
 databaseLogger.info("System Administrator has just signed on.");
 ...


Any ideas?

Thanks,

Frank.


---------------------------------------------------------------------
To unsubscribe, e-mail: log4j-user-unsubscribe@logging.apache.org
For additional commands, e-mail: log4j-user-help@logging.apache.org


Mime
View raw message