Re: [log4j] JDBCAppender: WHat am I doing wrong?

[Andreas Guther]

Frank:
Could id be that the order of appender and logging level plays a role?  
I am not  100% sure but my first guess is to have first the appender 
listed and last the log level, i.e. in your case

log4j.logger.sysadmin.databaselogging = R5, INFO
Andreas
Frank Burns wrote:
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]