P6SPY 2.0 发布,SQL 语句拦截

oschina
 oschina
发布于 2014年03月08日
收藏 72

8年过去了,P6SPY 发布了全新稳定版本 2.0 ,P6Spy是一个可以用来在应用程序中拦截和修改数据操作语句的开源框架。 通过P6Spy我们可以对SQL语句进行拦截,相当于一个SQL语句的记录器,这样我们可以用它来作相关的分析,比如性能分析。

下载地址:https://github.com/p6spy/p6spy/wiki/Download

详细改进内容包括:

  • project hosting was moved from sourceforge to github,

  • major part of the legacy code was refactored,

  • Java 6/7 JDBC API support introduced,

  • proxying via modified JDBC URLs only was implemented,
    So for for MySQL original url would be:

    jdbc:mysql://<hostname>:<port>/<database>

    the one proxied via p6spy would one:

    jdbc:p6spy:mysql://<hostname>:<port>/<database>

    without a need for any further configuration,

  • XA Datasource support has been introduced,

  • configuration via:

    • system/environment properties and

    • JMX properties

    • as an alternative to file configuration only

    • or even zero config use case supported,

  • slf4j support (more flexible as previously used log4j),

  • junit tests were migrated to junit 4 (well most of the old ones were failing anyway),

  • Continuous integration using Travis was setup providing testing on popular:

    • DB systems (namely: Oracle, DB2, PostgreSQL, MySQL, H2, HSQLDB, SQLite, Firebird, and Derby), see build status on: travis-ci as well as

    • application servers (namely: Wildfly 8, JBoss 4.2, 5.1, 6.1, 7.1, Glassfish 3.1, 4.0, Jetty 7.6, 8.1, 9.1, Tomcat 6, 7, 8, Resin 4, Jonas 5.3 and Geronimo 2.1, 2.2), see build status on: travis-ci.

完整的改进记录请看 2.0.0-alpha12.0.0.

本站文章除注明转载外,均为本站原创或编译。欢迎任何形式的转载,但请务必注明出处,尊重他人劳动共创开源社区。
转载请注明:文章转载自 OSCHINA 社区 [http://www.oschina.net]
本文标题:P6SPY 2.0 发布,SQL 语句拦截
加载中

最新评论(4

开源狂人
开源狂人
我的妈呀,作者还在呀,感觉十年没更新了。
牛三儿
牛三儿
下载地址中啥也木有
l
linsea
用过,不错,可用于跟踪完整的sql
返回顶部
顶部