log4j连接数据库不能插入数据,该怎么处理

log4j连接数据库不能插入数据
log4j.properties:

Java code

log4j.rootLogger=databaselog4j.appender.database=org.apache.log4j.jdbc.JDBCAppenderlog4j.appender.database.URL=jdbc:mysql://localhost:3306/logtestlog4j.appender.database.driver=com.mysql.jdbc.Driverlog4j.appender.database.user=rootlog4j.appender.database.password=zhangyilinlog4j.appender.database.sql=insert into t_log(level,location,message,proTime) values('%p','%c{1}','%m','%d')log4j.appender.database.layout=org.apache.log4j.PatternLayout

java程序：

Java code

import org.apache.log4j.Logger;public class Log4jDbTest {    public static void main(String args[]) {        System.out.println("----------------------------");        Logger log = Logger.getLogger(Log4jDbTest.class);        log.info("hello");        System.out.println("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^");    }    }

[解决办法]
DB
=============
CREATE TABLE `t_log` (
`level` VARCHAR(100) COLLATE utf8_general_ci DEFAULT NULL,
`location` VARCHAR(500) COLLATE utf8_general_ci DEFAULT NULL,
`message` VARCHAR(500) COLLATE utf8_general_ci DEFAULT NULL,
`proTime` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00'
)ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'
COMMENT='InnoDB free: 8192 kB';
=====================
log4j.properties:
===================
log4j.rootLogger=INFO，database
log4j.appender.database=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.database.URL=jdbc:mysql://localhost:3306/test
log4j.appender.database.driver=com.mysql.jdbc.Driver
log4j.appender.database.user=root
log4j.appender.database.password=123456
log4j.appender.database.sql=insert into t_log(level,location,message,proTime) values('%p','%c{1}','%m','%d{yyyy-MM-dd HH:mm:ss}')
log4j.appender.database.layout=org.apache.log4j.PatternLayout

====================================

public static void main(String args[]) {
System.out.println("----------------------------");
Logger log = Logger.getLogger(Log4jDbTest.class);
log.info("hello");
System.out.println("^^^^^^^^^^^^^^^^^^^^^^^^^^^^^");
}

查看更多 下一篇