log4j向oracle中插入一条系统当前时间的sql语句

时间：2023-03-08 18:57:29

配置log4j，要向oracle插入一条系统当前时间的sql语句，按网上查找的总是出现各种各样的报错，最后总结出的写法是:

 ### shezhi###

 log4j.rootLogger = debug,stdout,D,E,db

 log4j.appender.stdout = org.apache.log4j.ConsoleAppender

 log4j.appender.stdout.Target = System.out

 log4j.appender.stdout.layout = org.apache.log4j.PatternLayout

 log4j.appender.stdout.layout.ConversionPattern = [%-5p] %d{yyyy-MM-dd HH:mm:ss,SSS} method:%l%n%m%n

 ###  输出info级别以上的信息到E://logs/error.log ###

 log4j.appender.D = org.apache.log4j.DailyRollingFileAppender

 log4j.appender.D.File = E://logs/log.log

 log4j.appender.D.Append = true

 log4j.appender.D.Threshold = INFO

 log4j.appender.D.layout = org.apache.log4j.PatternLayout

 log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss}  [ %t:%r ] - [ %p ]  %m%n

 ########################  

 # JDBC Appender  

 #######################  

 ###info

 log4j.rootLogger=INFO,stdout

 log4j.logger.com=INFO,db  

 log4j.appender.db=com.neam.commons.MyJDBCAppender  

 log4j.appender.db=org.apache.log4j.jdbc.JDBCAppender

 log4j.appender.db.BufferSize=1

 log4j.appender.db.driver=oracle.jdbc.driver.OracleDriver

 log4j.appender.db.URL=jdbc:oracle:thin:@127.0.0.1:1521:ORCL

  log4j.appender.db.user=数据库名字

 log4j.appender.db.password=数据库密码  
###to_date(substr('%d',0,19),'yyyy-MM-dd hh24:mi:ss')这个是按系统当前时间插入到数据库

 log4j.appender.db.sql=insert into tableExc (excID, class, createTime, logLevel, msg) values (exc_id_seq.nextval,'%C',to_date(substr('%d',0,19),'yyyy-MM-dd hh24:mi:ss'),'%p', '%m')

 log4j.appender.db.layout=org.apache.log4j.PatternLayout

相关文章