问题描述:
使用log4j尝试将异常输出到文件,或者数据库,配置如下
log4j.rootLogger=INF,console,fileAppender,JDBC
log4j.logger.akka=INFO
log4j.logger.org.apache.kafka=INFO
log4j.logger.org.apache.hadoop=INFO
log4j.logger.org.apache.zookeeper=INFO
log4j.logger.org.apache.kafka.clients.consumer.ConsumerConfig=ERROR
log4j.appender.console=org.apache.log4j.ConsoleAppender
log4j.appender.console.layout=org.apache.log4j.EnhancedPatternLayout
log4j.appender.console.layout.ConversionPattern=%d{yyyy-MM-dd HH:mm:ss,SSS} %-5p %-60c %x -%m%n
log4j.logger.org.apache.flink.shaded.akka.org.jboss.netty.channel.DefaultChannelPipeline=ERROR, console,fileAppender
log4j.appender.fileAppender = org.apache.log4j.FileAppender
log4j.appender.fileAppender.File = G:/logs/log1.log
log4j.appender.fileAppender.Append = false
log4j.appender.fileAppender.layout =org.apache.log4j.EnhancedPatternLayout
log4j.appender.fileAppender.layout.ConversionPattern = %d{yyyy-MM-dd HH:mm:ss,SSS} %-5p %-60c %x - %m%n %throwable
#JDBC configure
log4j.appender.JDBC=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.JDBC.driver=com.mysql.jdbc.Driver
log4j.appender.JDBC.URL=jdbc:mysql://192.168.8.113:30193/data-platform?characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&serverTimezone=Asia/Shanghai
log4j.appender.JDBC.user=root
log4j.appender.JDBC.password=RE4PNygqa38W2gOj
log4j.appender.JDBC.layout=org.apache.log4j.PatternLayout
log4j.appender.JDBC.sql=INSERT INTO logging_job(jobid,logtime,loglevel,thread,location,message) VALUES ('${jobid}','%d{YYYY-MM-dd HH:mm:ss.SSS}','%p','[%t]','%l','%m%n%throwable')
如下面截图所示,异常只输出在控制台,没有写入文件,数据库
解决方案:
org.apache.log4j.EnhancedPatternLayout写入文件
1、修改log4j.properties
2、需要在可能出错的地方捕获异常,并使用log.error打印
通过上述步骤之后,可以看到控制台,文件都有异常写入了,但是数据库没有写入
数据库无法写入的原因是JDBCAppender默认设置的layout是PatternLayout,因此我们需要继承JDBCAppender,并重写setSql方法。
public class Log4JdbcAppender extends JDBCAppender {
private static final Logger log = LoggerFactory