logging-log4j-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Guther <andreas.gut...@guther.com>
Subject Re: [log4j] JDBCAppender: WHat am I doing wrong?
Date Sun, 06 Jun 2004 15:54:37 GMT
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: log4j-user-unsubscribe@logging.apache.org
>For additional commands, e-mail: log4j-user-help@logging.apache.org
>
>
>  
>


---------------------------------------------------------------------
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