xhj19872008 2015-11-12 03:37
浏览 1035

用log4j打印mybatis 连接数据库SQL语句无法打印,用的是c3po连接池

log4j配置如下:
log4j.rootLogger=info, stdout,file

log4j.logger.org.springframework=INFO
log4j.logger.org.springframework=ERROR

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=[%d] %-5p %c %L %x - %m%n
log4j.logger.com.credata.dao.assetmagt=trace
log4j.appender.file=org.apache.log4j.DailyRollingFileAppender
log4j.appender.file.DatePattern='.'yyyy-MM-dd
log4j.appender.file.Encoding=UTF-8
log4j.appender.file.File=d:/log/numprest.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d %5p [%t-%X] %c(%F:%L) - %m%n

打印控制台信息如下:
[2015-11-12 11:37:13,742] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource 462 - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 3000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgfevb9c1xav6gr1fjvgn4|515f9503, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> oracle.jdbc.driver.OracleDriver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgfevb9c1xav6gr1fjvgn4|515f9503, idleConnectionTestPeriod -> 60, initialPoolSize -> 5, jdbcUrl -> jdbc:oracle:thin:@172.20.8.187:1521:bppmdb, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
[2015-11-12 11:37:14,721] INFO com.nantian.nump.rest.DeviceRest 47 - 测试通过
[2015-11-12 11:37:15,327] INFO com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource 462 - Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 2, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 3000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgfevb9c1xav6gr1fjvgn4|6c540ae7, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.ibm.db2.jcc.DB2Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgfevb9c1xav6gr1fjvgn4|6c540ae7, idleConnectionTestPeriod -> 60, initialPoolSize -> 5, jdbcUrl -> jdbc:db2://172.20.8.188:50001/nrptdev, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 60, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, numThreadsAwaitingCheckoutDefaultUser -> 0, preferredTestQuery -> null, properties -> {user=******, password=******}, propertyCycle -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, usesTraditionalReflectiveProxies -> false ]
[com.nantian.nump.bean.Server@42433dc1, com.nantian.nump.bean.Server@4c8b6be3, com.nantian.nump.bean.Server@55582b57, com.nantian.nump.bean.Server@f858887]
[2015-11-12 11:37:15,893] INFO com.nantian.nump.rest.DeviceRest 59 - 采集数据成功!

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥30 matlab解优化问题代码
    • ¥15 写论文,需要数据支撑
    • ¥15 identifier of an instance of 类 was altered from xx to xx错误
    • ¥100 反编译微信小游戏求指导
    • ¥15 docker模式webrtc-streamer 无法播放公网rtsp
    • ¥15 学不会递归,理解不了汉诺塔参数变化
    • ¥15 基于图神经网络的COVID-19药物筛选研究
    • ¥30 软件自定义无线电该怎样使用
    • ¥15 R语言mediation包做中介分析,直接效应和间接效应都很小,为什么?
    • ¥15 Jenkins+k8s部署slave节点offline