Re: Is there any way to know the exact SQL statement passed from IBATIS to Database

[Nathan Maves]

this topic is covered on the wiki

On 12/13/06, Tony Qian <[EMAIL PROTECTED]> wrote:

add following in your log4j.xml

    <!-- Loggers for  iBATIS -->
     <logger name="com.ibatis" additivity="false">
         <level value="debug"/>
         <appender-ref ref="iBATISAppender"/>
     </logger>

     <!-- Loggers for sql -->
     <logger name="java.sql" additivity="false">
         <level value="debug"/>
         <appender-ref ref="iBATISAppender"/>
     </logger>

of course, you have to define "iBATISAppender" first.

Tony



John Chien wrote on 12/13/2006, 4:05 PM:

> Dear Sir:
>
> How can I find the exact SQL statement I passed from IBATIS to database
?
> Is there anyway to find out ?
>
> Thanks,
>
> John Chien
> john.chien.vcf