how to do Ibatis version of show sql

Question

Is there an Ibatis setting to view the generated SQL like how Hibernate has show_sql=true?

thanks

Duplicated: http://stackoverflow.com/questions/2635058/ibatis-get-executed-sql — leonbloy, Jun 10 '10 at 16:04

score 6 · Accepted Answer · answered Jun 10 '10 at 12:36

6

Yes, turn up it's logging level.

answered Jun 10 '10 at 12:36

matt b

138,234
66
282
345

score 0 · Answer 2 · edited Oct 10 '12 at 20:47

You could try p6spy.

This is not exactly a Ibatis property setting to view the generated SQLs. p6spy is a kind of library you can easily plugin to your Java application.

It logs you the generated sql and also resultSet (Which is great, actually). I used for issue tracking in dynamic queries. It prints it in a log file.

This mkyong blog may give you how-to integrate it with your Ibatis. (mkyong-blog-fan :))

score 0 · Answer 3 · edited May 23 '17 at 12:13

0

No, you can't. Log it in your database server.

http://www.apachebookstore.com/confluence/oss/display/IBATIS/How+do+I+get+SqlMapClient+to+log+SQL+statements

iBatis get executed sql

edited May 23 '17 at 12:13

Community

1
1

answered Jun 10 '10 at 16:05

leonbloy

73,180
20
142
190

how to do Ibatis version of show sql

3 Answers3