开发者社区 问答 正文

springmvc整合log4j日志写入数据库问题?报错

框架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',这样导致错误的吗?有什么好的解决办法


展开
收起
爱吃鱼的程序员 2020-06-10 14:36:12 817 分享 版权
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    <aclass='referer'target='_blank'>@村口加瓦佬你的这个问题怎么解决的呀,我的问题跟你一样,与SpringMVC整合了。log4j.properties文件里配置了Sql启动就报错了,注释掉了就没有问题。<divclass='ref'>

    引用来自“hnaxing”的评论

    <aclass='referer'target='_blank'>@村口加瓦佬你的这个问题怎么解决的呀,我的问题跟你一样,与SpringMVC整合了。log4j.properties文件里配置了Sql启动就报错了,注释掉了就没有问题。

    2020-06-10 14:36:27
    赞同 展开评论