Using iBatis , How to get the SQL Statement that is executed based on SQL Id ?

[Naresh Jagatap]

Hi ,

 

I have the iBatis SQL Id  using which I need to get the corresponding  SQL Statement.

So I have written the below code . as of now this code seems to be working. but just want to know whether my approach is correct ?

 

 

SqlMapExecutorDelegate delegate = sqlMapClient.getDelegate();

MappedStatement mappedStatement = delegate.getMappedStatement(sqlId);

Sql sql = mappedStatement.getSql();

SessionScope sessionScope = new SessionScope();

StatementScope statementScope = new StatementScope(sessionScope);

mappedStatement.initRequest(statementScope);

String sqlExecuted = sql.getSql(statementScope,object);

[c c]

if you config you log4j
you can easy see the sql in consloe;




2012/5/25 Naresh Jagatap <nare...@gmail.com>:

[Dridi Boukelmoune]

Hi,

I believe it has been moved to the BoundSql class.
You can get the query from your mapped statement :

String sqlExecuted = mappedStatement.getBoundSql(statementScope,object).getSql();

Dridi
http://www.zenika.com/

--
 

Dridi Boukelmoune Développeur/Formateur GSM : +33 (0)6 17 91 14 23 dridi.bo...@zenika.com 51, rue le Peletier - 75009 Paris Tel : +33 (0)1 45 26 19 15