retrieving the generated sql

[Richard Beacroft]

Hi,

We are looking to use iBatis to generate complex sql based on a set of
rules. The framework seems to be a good fit for this purpose.

However, it appears that at present, there is no way to retrieve the
sql that "would" be run, without executing it.

This would be useful for not just debugging, but sometimes it is worth
storing the generated sql for later execution.

Any plans to make this available?

Regards,
Rik

[丰刘]

Loogging of iBatis will show the SQL.

You can check the URL http://ibatis.apache.org/docs/dotnet/datamapper/ch04s05.html#id402380

App.config/Web.config:

  <configSections>

    <sectionGroup name="iBATIS">

      <section name="logging" type="IBatisNet.Common.Logging.ConfigurationSectionHandler, IBatisNet.Common" />

    </sectionGroup>

    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />

  </configSections>

...

And reference IBatisNet.Common.Logging.Log4Net.dll, log4net.dll to your project.

2012/3/4 Richard Beacroft <r_bea...@hotmail.com>

--
Thanks
Liu Feng