ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rose, Greg" <Greg.R...@starwoodvo.com>
Subject RE:iBATIS and log4j
Date Tue, 07 Feb 2006 12:28:26 GMT
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