We have a monitor that displays stats for every sql statement executed on our system. When a query starts the monitor displays "STARTING <sql> at <time> ..."

When the query completes the monitor displays "COMPLETED <sql> Duration <duration> ..."

I know Hibernate has a show_sql flag to have it log its sql. But is there a programmatic way to get the generated sql, so that I can do something like (main desire is to put entry at start-query, and then update entry at end-query):




Cheers
[/code]

I don't think you can do that programmatically, but you could perhaps use p6spy to produce sql log output . One of the things P6Spy outputs is the execution time for a query.

You could then parse the logs and get the query and execution time. Or write your own log4j appender to capture the log statements as they happen and do what you need with them right then.

P6Spy is available at http://www.p6spy.com/ .

Daniel