在log4j.properties中配置如下:
log4j.rootLogger=DEBUG, A1
# A1 is set to be a ConsoleAppender which outputs to System.out.
# JDBC appender directly
log4j.appender.A1=org.apache.log4j.jdbcplus.JDBCAppender
log4j.appender.A1.url=jdbc:mysql://192.168.26.71:3306/test
log4j.appender.A1.dbclass=org.gjt.mm.mysql.Driver
log4j.appender.A1.username=root
log4j.appender.A1.password=
#log4j.appender.A1.sql=INSERT INTO LOG_LOG4J2 (MSG) VALUES (@MSG@)
#next: example for most functions/log types
log4j.appender.A1.sql=INSERT INTO dx_log_tab (id, prio, cat, thread, msg, layout_msg, throwable, ndc, mdc, mdc2, layout, created_on, created_by, dx_cat,dx_flow_name,dx_com_name) VALUES (@INC@, @PRIO@, @CAT@, @THREAD@, @MSG@, @LAYOUT_MSG@, @THROWABLE@, @NDC@, @MDC:MyMDC@, @MDC:MyMDC2@, date_format('@LAYOUT_1@ @LAYOUT_2@', '%Y-%m-%d'), sysdate(), 'me', @DX_CAT@, @DX_FLOW_NAME@, @DX_COM_NAME@)
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=[%t] %m
#special layout patterns
log4j.appender.A1.layout1=%d{yyyy-MM-dd}
log4j.appender.A1.layout2=%d{HH:mm:ss}
log4j.appender.A1.buffer=1
log4j.appender.A1.commit=Y
log4j.rootLogger=DEBUG, A1
# A1 is set to be a ConsoleAppender which outputs to System.out.
# JDBC appender directly
log4j.appender.A1=org.apache.log4j.jdbcplus.JDBCAppender
log4j.appender.A1.url=jdbc:mysql://192.168.26.71:3306/test
log4j.appender.A1.dbclass=org.gjt.mm.mysql.Driver
log4j.appender.A1.username=root
log4j.appender.A1.password=
#log4j.appender.A1.sql=INSERT INTO LOG_LOG4J2 (MSG) VALUES (@MSG@)
#next: example for most functions/log types
log4j.appender.A1.sql=INSERT INTO dx_log_tab (id, prio, cat, thread, msg, layout_msg, throwable, ndc, mdc, mdc2, layout, created_on, created_by, dx_cat,dx_flow_name,dx_com_name) VALUES (@INC@, @PRIO@, @CAT@, @THREAD@, @MSG@, @LAYOUT_MSG@, @THROWABLE@, @NDC@, @MDC:MyMDC@, @MDC:MyMDC2@, date_format('@LAYOUT_1@ @LAYOUT_2@', '%Y-%m-%d'), sysdate(), 'me', @DX_CAT@, @DX_FLOW_NAME@, @DX_COM_NAME@)
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.layout.ConversionPattern=[%t] %m
#special layout patterns
log4j.appender.A1.layout1=%d{yyyy-MM-dd}
log4j.appender.A1.layout2=%d{HH:mm:ss}
log4j.appender.A1.buffer=1
log4j.appender.A1.commit=Y
解决方案 »
- java.io.InputStream的read()和read(byte[] b)和read(byte[] b, int off, int len)有什么不同
- JDK 配置问题。
- java code 在cmd上报了几个小错,高手进来看看
- 求教用Java实现网站数据采集方案?
- JAVA如何找到操作系统的路径
- 关于 checkbox 的 checked 的问题
- 请教:Java中的系统属性与.properties文件的自动加载
- 初学者问个简单的问题,望英雄指点,里面说
- Java内部类的一个编译错误,帮我看看
- 谁有Jbuilder6不过期的license,小弟千万分感谢,另奉上300作为报酬,求求各位,行个好吧
- 'H'是72对应的ASCII码,如何将72转化到字符'H'.
- help, 超大String和byte[]
可以到网上去下
#A1 is for production deployment
log4j.rootLogger=INFO, A1
log4j.appender.A1=org.apache.log4j.RollingFileAppender
log4j.appender.A1.File=D:\\work\\j2ee.log
log4j.appender.A1.layout=org.apache.log4j.PatternLayout
log4j.appender.A1.MaxFileSize = 100KB
log4j.appender.A1.layout.ConversionPattern=%-5p: [%37c %3x] - %m%n
发错了,这是支持写入文件的
hibernate的Log4j appender