ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Davide Marche <ja...@email.it>
Subject Re: iBATIS and log4j
Date Tue, 07 Feb 2006 14:03:08 GMT
Hi Greg and thank you,

may I ask you if you initialize log4j somehow ?

Rose, Greg ha scritto:
>
> 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
>
> com.starwood.svo.ice.business.object.ICEAccessControlList@1cba87[aclList=[]]
>
> 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.
>   



Mime
View raw message