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 14:18:00 GMT

In my case, I use Spring and have the following in my web.xml file:

<!--
	  - Location of the Log4J config file, for initialization and
refresh checks.
	  - Applied by Log4jConfigListener.
	  -->
	<context-param>
		<param-name>log4jConfigLocation</param-name>
	
<param-value>/WEB-INF/conf/log4j.properties</param-value>
	</context-param>
	
	<!--
	  - Key of the system property that should specify the root
directory of this
	  - web app. Applied by WebAppRootListener or
Log4jConfigListener.
	  -->
	<context-param>
		<param-name>webAppRootKey</param-name>
		<param-value>ICE.root</param-value>
	</context-param>


	<!--
	  - Configures Log4J for this web app.
	  - As this context specifies a context-param
"log4jConfigLocation", its file path
	  - is used to load the Log4J configuration, including periodic
refresh checks.
	  -
	  - Would fall back to default Log4J initialization
(non-refreshing) if no special
	  - context-params are given.
	  -
	  - Exports a "web app root key", i.e. a system property that
specifies the root
	  - directory of this web app, for usage in log file paths.
	  - This web app specifies "example.root" (see log4j.properties
file).
	  -->
	<listener>
	
<listener-class>org.springframework.web.util.Log4jConfigListener</listen
er-class>
	</listener>

-----Original Message-----
From: Davide Marche [mailto:javac@email.it] 
Sent: Tuesday, February 07, 2006 9:03 AM
To: user-java@ibatis.apache.org
Subject: Re: iBATIS and log4j

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


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