把log4j日志信息输出到数据库

日志输出类：

package com.dada.pager;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;

public class Hibernate_Util {

	private static final Log log = LogFactory.getLog(Hibernate_Util.class);

	//生成sessionFactory
	static {
		try {
			log.error("log is success！");
		} catch (Exception e) {
			log.error("%%%% Error Creating SessionFactory %%%%");
			e.printStackTrace();
		}
	}


}

 

log4j配置文件：

log4j.rootLogger=ERROR,DATABASE
log4j.addivity.org.apache=true

log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DATABASE.URL=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8

log4j.appender.DATABASE.driver=org.gjt.mm.mysql.Driver
log4j.appender.DATABASE.user=root
log4j.appender.DATABASE.password=test
log4j.appender.DATABASE.sql=INSERT INTO LOG4J (Message) VALUES ('[framework] %d - %c -%-4r [%t] %-5p %c %x - %m%n')
log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout
log4j.appender.DATABASE.layout.ConversionPattern=[framework] %d - %c -%-4r [%t] %-5p %c %x - %m%n

 

当此类初始化的时候就会想数据库中插入日志

效果如下图：