How log all data access on Ibatis and Hibernate

[danilo_lr]

Hi,

I need to log all database access on a application.
The app uses Hibernate and IBatis to database access.

The log must have the sql command and the parameters to it.
I do not want to use the log options of hibernate and ibatis because i want to be able to read the data in a easy format. And the native log create some things I do not need and some things I need are missing.
Any idea ?

Danilo.

[robh]

Danilo,

Would something like P6Spy (http://www.p6spy.com/) help you out, or are you in need of something else?

Rob

[danilo_lr]

Rob,

Thanks for your help.
I am evaluating P6Spy and it looks very good. Easy Spring integration too.
I need to test a bit more with data type like BLOB to see if it works correctly.

Danilo.