p6spy 2.0.0 is out!

After 8 years P6spy came to it’s next stable release!
You can get it here.

The last stable release happened (based on maven central repo) on 27-Dec-2005 (1.3 version). That is quite some time, so one would expect many things to happen in the meantime. Well the truth is that project was (half) dead for quite some time.

Changes

I can’t comment on full history since 1.3 release (since my interest in project started last summer), still I’ve noticed following:

• 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.

Full changelog

For the full changelog, see issues fixed in: 2.0.0-alpha1 as well as 2.0.0.