log4j配置好后，日志不能够输出到数据库中，求指教

Question

资源文件中的内容如下：[code="java"]log4j.propertieslog4j.rootLogger=INFO,stdoutlog4j.logger.org.springframework.web.servlet=INFO,dblog4j.logger.org.springframework.beans.factory.xml=INFOlog4j.logger.com.neam.stum.user=INFO,dblog4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss} %p [%c] - - <%m>%nlog4j.appender.logfile=org.apache.log4j.DailyRollingFileAppenderlog4j.appender.logfile.File=${webapp.root}/WEB-INF/logs/exppower.loglog4j.appender.logfile.DatePattern=.yyyy-MM-ddlog4j.appender.logfile.layout=org.apache.log4j.PatternLayoutlog4j.appender.logfile.layout.ConversionPattern=%d %p [%c] wang- <%m>%n########################JDBC Appender########################log4j.logger.business=INFO,db#log4j.appender.db=com.neam.commons.MyJDBCAppenderlog4j.appender.db=org.apache.log4j.jdbc.JDBCAppenderlog4j.appender.db.BufferSize=10log4j.appender.db.sqlname=loglog4j.appender.db.driver=com.mysql.jdbc.Driverlog4j.appender.db.URL=jdbc:mysql://172.20.92.139:3306/test?characterEncoding=UTF-8log4j.appender.db.user=rootlog4j.appender.db.password=123456log4j.appender.db.sql=insert into log(username,class,methodname,createtime,logLevel,msg) values ('%X{username}','%C','%M','%d{yyyy-MM-dd HH:mm:ss}','%p','%m')log4j.appender.db.layout=org.apache.log4j.PatternLayout[/code]运行时的测试类如下：[code="java"]import java.net.URL;import org.apache.log4j.Logger;import org.apache.log4j.MDC;import org.apache.log4j.PropertyConfigurator;public class TestClass {public static void main(String[] args) {     URL url = TestClass.class.getClassLoader().getResource("log4j.properties");     MDC.put("username", "username");     PropertyConfigurator.configure(url.getPath());     Logger logger  =  Logger.getLogger(TestClass.class);     logger.debug( " debug " );     logger.error( " error " );     logger.info(" info "); }}

Answer 1

Logger logger = Logger.getLogger(TestClass.class);

需要定义
log4j.logger.TestClass=INFO,db