RE:iBATIS and log4j

[Rose, Greg]

I am using iBATIS 2.1.5.582 and Tomcat 5.5.12.  Here is an excerpt of my log4j.properties file that I have in my WEB-INF/lib/conf directory.   log4j.logger.com.ibatis=DEBUG log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG   log4j.logger.java.sql.Connection=DEBUG log4j.logger.java.sql.Statement=DEBUG log4j.logger.java.sql.PreparedStatement=DEBUG, a2 log4j.logger.java.sql.ResultSet=DEBUG     Sample output to console:   2006-02-07 07:27:00,531 DEBUG java.sql.Connection - {conn-100000} Connection 2006-02-07 07:27:00,671 DEBUG java.sql.PreparedStatement - {pstm-100001} PreparedStatement:    select    P.PERSONID     as id,    P.LOGON        as userName,    P.PASSWORD        as password,    P.RECORDSTATUSID  as recordStatusID,         R.RECORDSTATUSCODE as recordStatusCode,    R.RECORDSTATUSNAME as recordStatusName   from  PERSON P,       RECORDSTATUS R   where P.RECORDSTATUSID=R.RECORDSTATUSID                       AND              (P.LOGON = ? )                     2006-02-07 07:27:00,671 DEBUG java.sql.PreparedStatement - {pstm-100001} Parameters: [grose] 2006-02-07 07:27:00,671 DEBUG java.sql.PreparedStatement - {pstm-100001} Types: [java.lang.String] 2006-02-07 07:27:00,703 DEBUG java.sql.ResultSet - {rset-100002} ResultSet 2006-02-07 07:27:00,765 DEBUG java.sql.ResultSet - {rset-100002} Header: [id, userName, password, recordStatusID, recordStatusCode, recordStatusName] 2006-02-07 07:27:00,765 DEBUG java.sql.ResultSet - {rset-100002} Result: [2, grose, test, 1, A  , Active] 2006-02-07 07:27:00,781 DEBUG java.sql.Connection - {conn-100003} Connection 2006-02-07 07:27:00,796 DEBUG java.sql.PreparedStatement - {pstm-100004} PreparedStatement:    select    P.PERSONID as id,    P.FNAME    as firstName,    P.MNAME    as middleName,    P.LNAME    as lastName,        P.EMAILADDRESS     as emailAddress,    P.RECORDSTATUSID   as recordStatusID,         R.RECORDSTATUSCODE as recordStatusCode,    R.RECORDSTATUSNAME as recordStatusName   from  PERSON P,       RECORDSTATUS R   where P.RECORDSTATUSID=R.RECORDSTATUSID   and   P.PERSONID = ?  2006-02-07 07:27:00,796 DEBUG java.sql.PreparedStatement - {pstm-100004} Parameters: [2] 2006-02-07 07:27:00,796 DEBUG java.sql.PreparedStatement - {pstm-100004} Types: [java.lang.Long] 2006-02-07 07:27:00,796 DEBUG java.sql.ResultSet - {rset-100005} ResultSet 2006-02-07 07:27:00,796 DEBUG java.sql.ResultSet - {rset-100005} Header: [id, firstName, middleName, lastName, emailAddress, recordStatusID, recordStatusCode, recordStatusName] 2006-02-07 07:27:00,796 DEBUG java.sql.ResultSet - {rset-100005} Result: [2, Greg, null, Rose, null, 1, A  , Active] 2006-02-07 07:27:00,796 DEBUG java.sql.Connection - {conn-100006} Connection 2006-02-07 07:27:00,796 DEBUG java.sql.PreparedStatement - {pstm-100007} PreparedStatement:    select    RO.ROLEID   as id,    RO.ROLECODE   as code,    RO.ROLENAME   as name,      RO.ROLEDESC   as description,    RO.RECORDSTATUSID   as recordStatusID,         RS.RECORDSTATUSCODE as recordStatusCode,    RS.RECORDSTATUSNAME as recordStatusName     from  ROLE RO,       RECORDSTATUS RS,      ROLEALLOC RX   where RO.RECORDSTATUSID=RS.RECORDSTATUSID   and   RO.ROLEID = RX.ROLEID   and   RX.PERSONID = ?    2006-02-07 07:27:00,796 DEBUG java.sql.PreparedStatement - {pstm-100007} Parameters: [2] 2006-02-07 07:27:00,796 DEBUG java.sql.PreparedStatement - {pstm-100007} Types: [java.lang.Long] 2006-02-07 07:27:00,796 DEBUG java.sql.ResultSet - {rset-100008} ResultSet [EMAIL PROTECTED] This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the "From:" field.