I see that in my logs. I have log4j.jar in my classpath, and in my WEB-INF/classes/log4j.properties, I have the following (copied from the iBatis manual):
# SqlMap logging configuration... log4j.logger.com.ibatis=DEBUG log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG log4j.logger.com.ibatis.sqlmap.engine.cache.CacheModel=DEBUG log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientImpl=DEBUG log4j.logger.com.ibatis.sqlmap.engine.builder.xml.SqlMapParser=DEBUG log4j.logger.com.ibatis.common.util.StopWatch=DEBUG log4j.logger.java.sql.Connection=DEBUG log4j.logger.java.sql.Statement=DEBUG log4j.logger.java.sql.PreparedStatement=DEBUG log4j.logger.java.sql.ResultSet=DEBUG Works well for me. Ian. On Fri, Jul 18, 2008 at 3:42 PM, Tokajac <[EMAIL PROTECTED]> wrote: > > That's exactly the topic here. > My aim is to see SELECT * FROM... , INSERT INTO... > on the console when they're executed > > Any more ideas? > > > Regards > > > > > > > kiran vuppla wrote: >> >> Can we able to log the Queries (I mean what is the query/ query >> description) that are executed using IBatis? If so can some one let me >> know how to configure such that I would like to see the query description >> that is executed? >> >> Thanks, >> KV >> >> --- On Thu, 7/17/08, Giovanni Cuccu <[EMAIL PROTECTED]> wrote: >> >> From: Giovanni Cuccu <[EMAIL PROTECTED]> >> Subject: Re: iBatis Tomcat log4j IntelliJ IDEA >> To: [email protected] >> Date: Thursday, July 17, 2008, 1:40 PM >> >> Hi, >> in the log4j config file you have to configure the java.sql logger to >> debug >> Giovanni >> >> On Thu, Jul 17, 2008 at 8:34 PM, Tokajac <[EMAIL PROTECTED]> wrote: >>> >>> I'm working with Tomcat and Struts framework. >>> >>> I want to log SQL queries (SELECT, INSERT, UPDATE...) with log4j. >>> I configured log4j, it works fine for other logs. >>> >>> I don't know how can I get the queries that are executed? >>> >>> >>> Regards >>> -- >>> View this message in context: >> http://www.nabble.com/iBatis-Tomcat-log4j-IntelliJ-IDEA-tp18515069p18515069.html >>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. >>> >>> >> >> >> >> -- >> -------------------------------------------------------------------- >> "You don't know the power of dark side" - Darth Vader >> >> >> >> > > -- > View this message in context: > http://www.nabble.com/iBatis-Tomcat-log4j-IntelliJ-IDEA-tp18515069p18536463.html > Sent from the iBATIS - User - Java mailing list archive at Nabble.com. > >
