框架SpringMVC,log4j配置如下
log4j.properties
log4j.rootLogger=INFO,stdout
log4j.logger.org.springframework.web.servlet=INFO,db
log4j.logger.org.springframework.beans.factory.xml=INFO
log4j.logger.com.neam.stum.user=INFO,db
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{yyyy-MM-dd HH🇲🇲ss} %p [%c] - - <%m>%n
log4j.appender.logfile=org.apache.log4j.DailyRollingFileAppender
log4j.appender.logfile.File=${webapp.root}/WEB-INF/logs/exppower.log
log4j.appender.logfile.DatePattern=.yyyy-MM-dd
log4j.appender.logfile.layout=org.apache.log4j.PatternLayout
log4j.appender.logfile.layout.ConversionPattern=%d %p [%c] wang- <%m>%n
########################
# JDBC Appender
#######################
log4j.appender.db=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.db.BufferSize=1
log4j.appender.db.driver=com.mysql.jdbc.Driver
log4j.appender.db.URL=jdbc:mysql://localhost:3306/training_cms?useUnicode=true&characterEncoding=UTF-8
log4j.appender.db.user=root
log4j.appender.db.password=root
log4j.appender.db.sql=insert into log (class,mothod,create_time,log_level,msg) values ('%C','%M','%d','%p','%m')
log4j.appender.db.layout=org.apache.log4j.PatternLayout
启动报错
信息: Initializing log4j from [classpath:log4j.properties] 一月 26, 2016 3:42:33 下午 org.apache.catalina.core.ApplicationContext log 信息: Initializing Spring FrameworkServlet 'springmvc' log4j:ERROR Failed to excute sql com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'springmvc': initialization started')' at line 1是insert into log (class,mothod,create_time,log_level,msg) values ('%C','%M','%d','%p','%m') 执行错误,比如 %m的值包含'springmvc',然后'%m'等同'xx'springmvc'xx',这样导致错误的吗?有什么好的解决办法
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
<aclass='referer'target='_blank'>@村口加瓦佬你的这个问题怎么解决的呀,我的问题跟你一样,与SpringMVC整合了。log4j.properties文件里配置了Sql启动就报错了,注释掉了就没有问题。<divclass='ref'>