Monitoring SQL queries in the code

[vovik1]

Hi,
We are using Hibernate 3.1 along with JBOSS 4.0.3SP1 (MySQL 5.0 as database).
Is there is a programatical method to get information abot what SQL queries are currently executed by Hibernate and as a ideal situation to get information about how much time each query takes to execute.

We do use true
but it is not what we need( it just shows sql queries on the console). We need kind of "real time info" about queries that are executed right now.

Thanks.

[fbiaggi]

Hi,
try P6Spy or
https://sourceforge.net/projects/mysqa.