P6Spy lets you monitor the JDBC queries by proxying your database driver. In addition to logging the prepared statements, it also logs the sql with parameters in place so you can copy and paste the exact sql into your favourite database client to test the results.
This Griffon plugin makes it easy to utilize P6Spy in your Griffon applications. It is based on the Grails P6Spy plugin.
The current version of griffon-p6spy-plugin is 0.2
To install just issue the following command
griffon install-plugin p6spy |
This plugin contains 2 files - the p6spy jar and spy.properties. After installing the plugin in your Griffon application, you can find the properties file in:
The install script updates your DataSource.groovy to add a commented line containing the p6spy driver class:
Version |
Date |
Notes |
|---|---|---|
0.2 |
07-22-10 |
Release sync with Griffon 0.9 |
0.1 |
03-01-10 |
Initial release |