You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by John Chien <jo...@ncmail.net> on 2006/12/13 22:05:04 UTC
Is there any way to know the exact SQL statement passed from IBATIS
to Database
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
Re: Is there any way to know the exact SQL statement passed from IBATIS to
Database
Posted by c....@ads.it.
John Chien <jo...@ncmail.net> scritti il 13/12/2006 22:13:27
> I did not user logging.
> How do I use logging ?
SQL logging
http://www.mail-archive.com/user-java@ibatis.apache.org/msg00765.html
Other related topics if you search the list with "log4j"
ciao
Cesare
Re: Is there any way to know the exact SQL statement passed from
IBATIS to Database
Posted by John Chien <jo...@ncmail.net>.
I did not user logging.
How do I use logging ?
Nathan Maves wrote:
> Have you looked at enabling logging?
>
> If so what are you not seeing?
>
>
> On 12/13/06, *John Chien* <john.chien@ncmail.net
> <ma...@ncmail.net>> wrote:
>
> 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
>
>
>
Re: Is there any way to know the exact SQL statement passed from IBATIS to Database
Posted by Nathan Maves <na...@gmail.com>.
Have you looked at enabling logging?
If so what are you not seeing?
On 12/13/06, John Chien <jo...@ncmail.net> wrote:
>
> 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
>
>
>
Re: Is there any way to know the exact SQL statement passed from IBATIS to Database
Posted by Nathan Maves <na...@gmail.com>.
this topic is covered on the wiki
On 12/13/06, Tony Qian <da...@aol.com> 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
>
>
Re: Is there any way to know the exact SQL statement passed from IBATIS
to Database
Posted by Tony Qian <da...@aol.com>.
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