arthurblake / log4jdbc

log4jdbc is a Java JDBC driver that can log SQL and/or JDBC calls (and optionally SQL timing information) for other JDBC drivers using the Simple Logging Facade For Java (SLF4J) logging system.
516 stars 147 forks source link

a sql two output #51

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
problem:
  a sql two output

problem sample
※※※※※※※※※※※※※※※※※※※※※※※※※※��
�※※※※※※※※※※※※※※※※※※※※※※※※※※�
��※※
2012-07-31 12:08:35,431 [INFO ] sqltiming sqlTimingOccured - 
    insert 
    into
        USERINFO

    values
        ('wqeqw','213123','M','WAR,PEOPLE,','tianjin','dadfasf')  {executed in 31 msec}
2012-07-31 12:08:35,431 [INFO ] sqltiming sqlTimingOccured - 
    insert 
    into
        USERINFO

    values
        ('wqeqw','213123','M','WAR,PEOPLE,','tianjin','dadfasf')  {executed in 31 msec}
※※※※※※※※※※※※※※※※※※※※※※※※※※��
�※※※※※※※※※※※※※※※※※※※※※※※※※※�
��※※

log4j.properties's configuration
※※※※※※※※※※※※※※※※※※※※※※※※※※��
�※※※※※※※※※※※※※※※※※※※※※※※※※※�
��※※
# ルートはINFOレベルで stdout, file を使います。
log4j.rootCategory=INFO, stdout, file

# コンソール出力(stdout)
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d [%-5p] %c{1} %M - %m%n

## ファイル出力(file) ログファイルをローリングさせる場合
log4j.appender.file=org.apache.log4j.RollingFileAppender
log4j.appender.file.File=C:/app.log
log4j.appender.file.Append=true
## 最大1MBまで書き込みます
log4j.appender.file.MaxFileSize=1MB
## log/app.log.9 まで保持します
log4j.appender.file.MaxBackupIndex=9
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d [%-5p] %c{1} %M - %m%n

## log4jdbcの配置
log4j.logger.jdbc.sqlonly=OFF    
log4j.logger.jdbc.sqltiming=INFO    
log4j.logger.jdbc.audit=OFF    
log4j.logger.jdbc.resultset=OFF    
log4j.logger.jdbc.connection=OFF   
※※※※※※※※※※※※※※※※※※※※※※※※※※��
�※※※※※※※※※※※※※※※※※※※※※※※※※※�
��※※

Original issue reported on code.google.com by sizhef...@gmail.com on 31 Jul 2012 at 5:33

GoogleCodeExporter commented 9 years ago
version Info:
 log4jdbc4-1.2.1.jar
 slf4j-1.6.6
 Spring3.1

Original comment by sizhef...@gmail.com on 31 Jul 2012 at 9:00