亲测可用
Mysql:
log4j.rootLogger = LOGDB2
数据库:
log4j.appender.LOGDB2=org.apache.log4j.jdbc.JDBCAppender
日志级别:
log4j.appender.LOGDB2.Threshold = ERROR
驱动:
log4j.appender.LOGDB2.Driver=com.mysql.jdbc.Driver
连接:
log4j.appender.LOGDB2.URL=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8
账号密码:
log4j.appender.LOGDB2.user=root
log4j.appender.LOGDB2.password=root
SQL:
log4j.appender.LOGDB2.sql=insert into log_test(level,category,thread,time,location,note) values("%p","%c","%t","%d{yyyy-MM-dd HH:mm:ss}","%l","%m")
输出:
log4j.appender.LOGDB2.layout=org.apache.log4j.PatternLayout
注意:sql中的values中的值要用双引号--("%p","%c","%t","%d{yyyy-MM-dd HH:mm:ss}","%l","%m"),用单引号会报错:log4j:ERROR Failed to excute sql
oracle没装,懒得测了,推荐一个,可以看下: