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
>
> [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.
>
