Hi Andreas,
Thanks for your interest.
> Could id be, that the order of appender and logging level plays a role?
They have to be in the order I specified. I changed them and got an error
saying that there was no appender named "INFO".
And all of my other appenders are defined this way, and they work perfectly.
Any other ideas?
Do YOU have a system working with JDBCAppender? Can you tell me how you have
configured it?
Thanks,
Frank.
----- Original Message -----
From: "Andreas Guther" <[EMAIL PROTECTED]>
To: "Log4J Users List" <[EMAIL PROTECTED]>
Sent: Sunday, June 06, 2004 4:54 PM
Subject: Re: [log4j] JDBCAppender: WHat am I doing wrong?
> 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]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
