log4j:ERROR Failed to excute sql

Question

这里是LOG4J的配置

log4j.rootLogger=debug,stdout,logfile,DATABASE

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:mm:ss} %p [%c] - - <%m>%n

log4j.appender.logfile=org.apache.log4j.DailyRollingFileAppender

log4j.appender.logfile.File=c:/home/smxgx/jsjs.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

log4j.addivity.org.apache=true

\u7528\u4e8e\u6570\u636e\u5e93

log4j.appender.DATABASE=org.apache.log4j.jdbc.JDBCAppender
log4j.appender.DATABASE.URL=jdbc:oracle:thin:@10.38.12.35:1521:smxgx
log4j.appender.DATABASE.driver=oracle.jdbc.driver.OracleDriver
log4j.appender.DATABASE.user=smxgx
log4j.appender.DATABASE.password=smxgx

\u672c\u5904\u8bbe\u7f6e\u4e3a"WARN"\u4ee5\u4e0a\u7ea7\u522b\u5728\u6570\u636e\u5e93\u5b58\u50a8(\u9ed8\u8ba4\u60c5\u51b5\u4f7f\u7528rootLogger\u4e2d\u7684\u8bbe\u7f6e)

log4j.appender.DATABASE.Threshold=DEBUG
log4j.appender.DATABASE.sql=INSERT INTO btrankline_log(id,optime,thread,infolevel,classname,message) VALUES (log_seq.nextval,'%d{yyyy-MM-dd HH:mm:ss}', '%t', '%p', '%l', '%m');

\u5199\u5165\u6570\u636e\u5e93\u4e2d\u7684\u8868LOG4J\u7684Message\u5b57\u6bb5\u4e2d\uff0c

\u5185\u5bb9\uff05d\uff08\u65e5\u671f\uff09%c: \u65e5\u5fd7\u4fe1\u606f\u6240\u5728\u5730\uff08\u7c7b\u540d\uff09%p: \u65e5\u5fd7\u4fe1\u606f\u7ea7\u522b%m: \u4ea7\u751f\u7684\u65e5\u5fd7\u5177\u4f53\u4fe1\u606f %n: \u8f93\u51fa\u65e5\u5fd7\u4fe1\u606f\u6362\u884c

log4j.appender.DATABASE.layout=org.apache.log4j.PatternLayout
log4j.appender.DATABASE.layout.ConversionPattern=[framework] %d - %c -%-4r [%t] %-5p %c %x - %m%n3

运行后报
log4j:ERROR Failed to excute sql
java.sql.SQLException: ORA-00917: missing comma

Answer 1

log4j.appender.DATABASE.sql=INSERT INTO btrankline_log(id,optime,thread,infolevel,classname,message) VALUES (log_seq.nextval,'%d{yyyy-MM-dd HH:mm:ss}', '%t', '%p', '%l', '%m')[b][color=red][size=x-large];[/size][/color][/b]

去掉[size=x-large][color=red];[/color][/size]