Anything better than P6Spy? [closed]

Question

I am planning to use P6Spy to intercept database statements within our architecture. However, I noticed on the P6Spy website that the last release of the software was back in 2003. Is there anything out there that is better or should I just stick with P6Spy?

Answer 1

Some other tools and libraries that are similiar to P6Spy.

• Craftsman Spy appears to overlap quite a bit with the feature set in log4jdbc. This library hasn't been updated in 2 years and depends on Jakarta Commons Logging.

• JAMon (Java Application Monitor) is a comprehensive application monitor and monitoring API which includes JDBC/SQL monitoring as part of it's very large feature set.

• JdbcProxy The driver can also emulate another JDBC driver to test the application without a database.

• LogDriver appears to be similiar to log4jdbc and the author has written a nice article on JDBC logging in general and his motivation and experience of writing LogDriver.

• yet another JDBC logger

• log4jdbc-remix an experimental fork of log4jdbc with some interesting features.

• jdbcdslog Another new jdbc wrapper with a lot of crossover with log4jdbc features.

• SqlRecorder A library that is a wrapper around a JDBC driver to record all executed queries to different locations like a file,console or any other remote server via plugins.

• log4jdbc-log4j2 Another fork of log4jdbc that includes the log4jdbc-remix fork and other features of it's own.

Source: https://code.google.com/archive/p/log4jdbc/