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

[Frank Burns <fr...@the-hub.demon.co.uk>]

And the problem was ... log4j.appender.R5.BufferSize=4096

When I remove this, or set it to a much lower value, then I get the
immediate logging output that I expect.

Thanks.

----- Original Message ----- 
From: "Frank Burns" <fr...@the-hub.demon.co.uk>
To: "Log4J Users List" <lo...@logging.apache.org>
Sent: Sunday, June 06, 2004 8:08 PM
Subject: Re: [log4j] JDBCAppender: WHat am I doing wrong?


> 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" <an...@guther.com>
> To: "Log4J Users List" <lo...@logging.apache.org>
> 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: 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
> >
>
>
> ---------------------------------------------------------------------
> 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