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.
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.
P6Spy has been under active development ago for a while now. The 2.0 version has also just been released. It now supports use without any configuration file for some use cases. It has also been updated to the JDBC 4.0 API and is fully compatible is Java 6 & 7.
I started using log4jdbc when p6spy wouldn't work on a precompile project that did its own driver discovery. log4jdbc has you change the DB connection url which we found simpler to setup. It also doesn't require a separate configuration file (spy.properties) and it is actively worked on. I'm not going to touch p6spy again.
发布评论
评论（4）
其他一些与 P6Spy 类似的工具和库。
Craftsman Spy 似乎与 log4jdbc 中的功能集有很多重叠。 该库已经 2 年没有更新过，依赖于 Jakarta Commons Logging。
JAMon（Java 应用程序监视器）是一个全面的应用程序监视器和监视 API，其中包括 JDBC/SQL 监视这是其庞大功能集的一部分。
JdbcProxy 该驱动程序还可以模拟另一个 JDBC 驱动程序来测试没有数据库的应用程序。
LogDriver 看起来与 log4jdbc 类似，并且作者写了一篇关于 JDBC 日志记录的好文章总的来说，以及他编写 LogDriver 的动机和经验。
又一个JDBC 记录器
log4jdbc- remix log4jdbc 的一个实验性分支，具有一些有趣的功能。
jdbcdslog 另一个新的 jdbc 包装器，与 log4jdbc 功能有很多交叉。
SqlRecorder 一个库，它是 JDBC 驱动程序的包装器，用于将所有执行的查询记录到不同的位置，例如通过插件的文件、控制台或任何其他远程服务器。
log4jdbc-log4j2 log4jdbc 的另一个分支，包括 log4jdbc-remix 分支和它自己的其他功能。
来源：https://code.google.com/archive/p/log4jdbc/
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/
P6Spy 已经积极开发了一段时间了。 2.0版本也刚刚发布。 对于某些用例，它现在支持在没有任何配置文件的情况下使用。 它还已更新为 JDBC 4.0 API，并且完全兼容 Java 6 和 Java 6。 7.
该项目目前也在 GitHub 上开发。 更新的文档也可用。
P6Spy has been under active development ago for a while now. The 2.0 version has also just been released. It now supports use without any configuration file for some use cases. It has also been updated to the JDBC 4.0 API and is fully compatible is Java 6 & 7.
The project is also being developed on GitHub now. Updated documentation is available as well.
当 p6spy 无法在自己进行驱动程序发现的预编译项目上工作时，我开始使用 log4jdbc 。 log4jdbc 让您更改数据库连接 URL，我们发现它更容易设置。 它也不需要单独的配置文件（spy.properties），并且正在积极开发中。 我不会再碰p6spy了。
I started using log4jdbc when p6spy wouldn't work on a precompile project that did its own driver discovery. log4jdbc has you change the DB connection url which we found simpler to setup. It also doesn't require a separate configuration file (spy.properties) and it is actively worked on. I'm not going to touch p6spy again.
我们仍然将 P6Spy 与带有 EJB2.0 的 Weblogic 8.1.5 一起使用，它的作用非常大。 我即将尝试将其与 Weblogic 10.3 和 EJB3.0 集成
We still use P6Spy with our Weblogic 8.1.5 with EJB2.0 and it works charms. I'm about to try and integrate it with Weblogic 10.3 and EJB3.0