急!关于log4j配置的问题,请高手进来帮忙解决一下!

wafer_w 2006-04-21 01:29:04

配置文件如下:
# Global logging configuration
log4j.rootLogger=debug,R
log4j.logger.gov=info,stdout,db

# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p [%t] %c{1}:%L - %m%n

#configure appender

log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=cdgsbridge.log
log4j.appender.R.MaxFileSize=1024KB
# Keep three backup files
log4j.appender.R.MaxBackupIndex=1
log4j.appender.R.layout=org.apache.log4j.PatternLayout
# Production version
#log4j.appender.R.layout.ConversionPattern=%d{ABSOLUTE} %5p [%t] %c{1} - %m%n

# Slow, caller context, debug version
log4j.appender.R.layout.ConversionPattern=%d{ABSOLUTE} %5p [%t] %c{1}:%L - %m%n

#db
log4j.appender.db = org.apache.log4j.jdbc.JDBCAppender
log4j.appender.db.BufferSize = 40
log4j.appender.db.Driver = net.sourceforge.jtds.jdbc.Driver
log4j.appender.db.URL = jdbc:jtds:sqlserver://91.20.19.21:1433;DatabaseName=cdgsbridge
log4j.appender.db.User = sa
log4j.appender.db.Password = 1
log4j.appender.db.layout = org.apache.log4j.PatternLayout
log4j.appender.db.layout.ConversionPattern = INSERT INTO log4j (createDate, priority, thread, category, message) values('%d{ABSOLUTE}', '%-5p', '%t', '%c', '%m')

---
我想达到的效果是:
log4j.logger.gov包下的日志输入到stdout ,db中,除此之外的其他日志输出到R中,但运行后发现log4j.logger.gov=info,stdout,db没有效果,但如果把db配置到log4j.rootLogger上信息又可以插入数据库,不知道是什么原因,请高手帮忙,急!

...全文