JDBC profiling tools

We need to profile the JDBC operations of several web applications, number of queries, time spent, rows returned, ...

Have you used any f开发者_运维知识库ree/commercial JDBC profiling tool? What are your experiences?

Thank you.

Now VisualVM supports JDBC profiling as well. Just have a look https://visualvm.github.io/download.html

The only JDBC profiling tool that I know is P6Spy. Ancient but still works.

Check out JAMon (Java Application Monitor) too. Also older, but works.

IntelliJ IDEA has a plugin called Fluid for HTTP and JDBC libraries. It seems to be actively developed.

I have never used it but have come across Elvyx. Again it has not been updated recently.

There is a JDBC profiler built in a JProfiler (go to Hotspots view -> JDBC), best thing I've seen so far...

You can use Jdbc spy: https://github.com/lbaeumer/jdbcspy.
It can be configured very easily and will provide information, which statements are executed, what are the statements with the longest duration, additional statistics about your connections, what statements are executed how often, etc.