P6SPY does not log INSERT AND UPDATE statements

[Maximiano Cumbe]

Hello,

We would like to have the log of the sql statements from our applications to the database, and we found p6spy as a good tool for our purpose.

Unfortunately, It does not log some statements. We are using hibernate for persistence, and most ou our functionalities are transactional. For many transaction it does not log the insert and update statements (we did not test anything for delete statements), but it logs the select statements for the same transactions. (We didn't find it clearly about the pattern of the functionalities that do not show these logs. Maybe it is for being in a transactional scope)

Is there any limitations for insert and update statements? Is there anything else to be configured to enable them to be logged?  

And what about the functionalities that are implemented in a transactional scope?