I got SQL Logging to work from browsing tips here, but I'm now seeing what look
like double-entries in my log, like so:
2007-06-15 15:35:53,243 {conn-101049} Connection
2007-06-15 15:35:53,243 {conn-101049} Connection
2007-06-15 15:35:53,243 {conn-101049} Preparing Statement: select
ASSETID, SEQNBR, ASSETSTAT, NOTETXT, DTOFUPDT, TMOFUPDT, STFOFUPDT,
OWNERFACL, CDPPSLOC, USERID from HZAZDB3.DCAV1AH1 where ASSETID
= ? order by SEQNBR desc
2007-06-15 15:35:53,243 {conn-101049} Preparing Statement: select
ASSETID, SEQNBR, ASSETSTAT, NOTETXT, DTOFUPDT, TMOFUPDT, STFOFUPDT,
OWNERFACL, CDPPSLOC, USERID from HZAZDB3.DCAV1AH1 where ASSETID
= ? order by SEQNBR desc
Just wondering if I'm really having things happen twice or is there something
else causing the double lines.
Here is the appropriate section from my log4j properties:
log4j.rootlogger=INFO, db_appender
log4j.logger.com.ibatis=INFO, db_appender
log4j.logger.java.sql=INFO, db_appender
log4j.logger.java.sql.Connection=DEBUG, db_appender
#log4j.logger.java.sql.Statement=DEBUG, db_appender
#log4j.logger.java.sql.PreparedStatement=DEBUG, db_appender
log4j.additivity.java.sql=false
log4j.additivity.com.ibatis=false
log4j.appender.db_appender=org.apache.log4j.DailyRollingFileAppender
log4j.appender.db_appender.DatePattern='.'yyyy-MM-dd
log4j.appender.db_appender.append=true
log4j.appender.db_appender.layout=org.apache.log4j.PatternLayout
log4j.appender.db_appender.layout.ConversionPattern=%d{ISO8601} %m%n
log4j.appender.db_appender.file=c:/logs/ibatis.log
Mark Collins
(919)716-3554
--------------------
"E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law and may be disclosed to third parties by an
authorized state official."
--------------------
