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 Prateek Asthana <hk...@gmail.com> on 2008/05/28 02:53:33 UTC

echo dynamic sql

Hi,
When using dynamic sql generation using the various tags, is it
possible to echo the final SQL query that will be executed against the
database. I understand the query will change depending upon the
various conditions and want to see what is the final SQL query which
is getting executed.

Thanks,
Prateek

Re: echo dynamic sql

Posted by Gwyn Evans <gw...@gmail.com>.

Note http://opensource.atlassian.com/confluence/oss/display/IBATIS/JDBC+logging+issues
too!
/Gwyn

On Thu, May 29, 2008 at 12:25 PM, Andrey Rogov <an...@gmail.com> wrote:
> iBatis Developers Guide, 65 page.
>
>
> 2008/5/29 Prateek Asthana <hk...@gmail.com>:
>>
>> Thanks Andre,
>> Can you please point me to teh documentation where its mentioned. I
>> would like to read it and implement it.
>>
>> Thanks
>> Prateek
>>
>>
>> On Wed, May 28, 2008 at 10:06 AM, Andrey Rogov <an...@gmail.com>
>> wrote:
>> > usually all use log4j.
>> > you can see and prepare Statement  and executing statement and .
>> > It is described in a documentation.
>> > Does it dislike you ?
>> >
>> >
>> > 2008/5/28 Prateek Asthana <hk...@gmail.com>:
>> >>
>> >> Hi,
>> >> When using dynamic sql generation using the various tags, is it
>> >> possible to echo the final SQL query that will be executed against the
>> >> database. I understand the query will change depending upon the
>> >> various conditions and want to see what is the final SQL query which
>> >> is getting executed.
>> >>
>> >> Thanks,
>> >> Prateek
>> >
>> >
>
>

Re: echo dynamic sql

Posted by Andrey Rogov <an...@gmail.com>.

iBatis Developers Guide, 65 page.


2008/5/29 Prateek Asthana <hk...@gmail.com>:

> Thanks Andre,
> Can you please point me to teh documentation where its mentioned. I
> would like to read it and implement it.
>
> Thanks
> Prateek
>
>
> On Wed, May 28, 2008 at 10:06 AM, Andrey Rogov <an...@gmail.com>
> wrote:
> > usually all use log4j.
> > you can see and prepare Statement  and executing statement and .
> > It is described in a documentation.
> > Does it dislike you ?
> >
> >
> > 2008/5/28 Prateek Asthana <hk...@gmail.com>:
> >>
> >> Hi,
> >> When using dynamic sql generation using the various tags, is it
> >> possible to echo the final SQL query that will be executed against the
> >> database. I understand the query will change depending upon the
> >> various conditions and want to see what is the final SQL query which
> >> is getting executed.
> >>
> >> Thanks,
> >> Prateek
> >
> >
>

Re: echo dynamic sql

Posted by Prateek Asthana <hk...@gmail.com>.

Thanks Andre,
Can you please point me to teh documentation where its mentioned. I
would like to read it and implement it.

Thanks
Prateek


On Wed, May 28, 2008 at 10:06 AM, Andrey Rogov <an...@gmail.com> wrote:
> usually all use log4j.
> you can see and prepare Statement  and executing statement and .
> It is described in a documentation.
> Does it dislike you ?
>
>
> 2008/5/28 Prateek Asthana <hk...@gmail.com>:
>>
>> Hi,
>> When using dynamic sql generation using the various tags, is it
>> possible to echo the final SQL query that will be executed against the
>> database. I understand the query will change depending upon the
>> various conditions and want to see what is the final SQL query which
>> is getting executed.
>>
>> Thanks,
>> Prateek
>
>

Re: echo dynamic sql

Posted by Andrey Rogov <an...@gmail.com>.

usually all use log4j.
you can see and prepare Statement  and executing statement and .
It is described in a documentation.
Does it dislike you ?


2008/5/28 Prateek Asthana <hk...@gmail.com>:

> Hi,
> When using dynamic sql generation using the various tags, is it
> possible to echo the final SQL query that will be executed against the
> database. I understand the query will change depending upon the
> various conditions and want to see what is the final SQL query which
> is getting executed.
>
> Thanks,
> Prateek
>