How to make Ibatis show sql show version

Question

Is there an Ibatis parameter to view the generated SQL, for example, how does Hibernate have show_sql = true?

thanks

Answer 1

Yes, enable its logging level .

Answer 2

No, you can’t. Write it to the database server.

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

iBatis get sql executed

Answer 3

You can try p6spy .

This is not exactly a property of the Ibatis property for viewing generated SQL queries. p6spy is a kind of library that you can easily connect to your Java application.

It registers you the generated sql and also resultSet (which is excellent, actually). I used problem tracking in dynamic queries. He prints it in a log file.

This mkyong blog can give you the opportunity to integrate it with your Ibatis. (mkyong-blog-fan :))