Urgent help needed with JDBCAppender

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

I urgently need some help to fix database logging on a production box, on which the db connections time out -- and logging stops!

So I wonder can you please help me with implementing the enhanced version of JDBCAppender ( from: http://www.mannhaupt.com/danko/projects/ ) with mySQL on Tomcat?

I have implemented database pooling for the database, so it is available to the app, via JNDI, as java:comp/env/jdbc/AmxTrcResources.

Here is part of my log4j.properties file:

log4j.logger.sysadmin.logins.successful = DEBUG, R5
log4j.appender.R5=org.apache.log4j.jdbcplus.JDBCAppender
log4j.appender.R5.buffer=1
log4j.appender.R5.dbclass=com.mysql.jdbc.Driver
log4j.appender.R5.connector=com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection
log4j.appender.R5.Sql=INSERT INTO LogsLoginsSuccessful (Date, Logger, Priority, Message) VALUES ('@LAYOUT@', '@CAT@', '@PRIO@', '@MSG@')
log4j.appender.R5.threshold=DEBUG
log4j.appender.R5.layout=org.apache.log4j.PatternLayout
log4j.appender.R5.layout.ConversionPattern=%d{dd MMM yyyy HH:mm:ss,SSS}
log4j.appender.R5.commit=true
log4j.appender.R5.quoteReplace=true

I think the problem is with this line:

    log4j.appender.R5.connector=com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection

The API documentation says that for "connector" I need to specify a JDBCConnectionHandler / JDBCPoolConnectionHandler, but where do I get one of these for mySQL?

I get this exception: 

log4j:ERROR JDBCAppender::configure()
java.lang.Exception: JDBCAppender::connect(), java.lang.InstantiationException:
com.mysql.jdbc.jdbc2.optional.MysqlPooledConnection
        at org.apache.log4j.jdbcplus.JDBCAppender.connect(JDBCAppender.java:879)
        at org.apache.log4j.jdbcplus.JDBCAppender.configure(JDBCAppender.java:897)
        at org.apache.log4j.jdbcplus.JDBCAppender.ready(JDBCAppender.java:819)
        at org.apache.log4j.jdbcplus.JDBCAppender.append(JDBCAppender.java:755)
        at org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:221)
        at org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:57)
        at org.apache.log4j.Category.callAppenders(Category.java:187)
        at org.apache.log4j.Category.forcedLog(Category.java:372)
        at org.apache.log4j.Category.warn(Category.java:1019)
...


Thanks,

Frank.