I'm looking to inspect SQL statements in Java/jdbc code to ensure that the SQL to be executed is of acceptable quality. Neither PMD not Findbugs appears to have JDBC or sql rules. I could use p6spy to log the SQL and look at that way, but this is manual. I'm wondering if the strategy of of using PMD/Findbugs/etc to create a rule that ...
I am looking for a tool that Logs SQL statemetns fired in the application as I use the application. I found p6spy. But there is an issue with that. It doesnt seem to be compatible with XA Datasources. Is there a way to make p6spy work on Websphere 6.1 OR is there an alternative to p6spy ? Also, if anyone has any AspectJ code that inte...
Is there a way to set the filter in p6spy, such that it only logs "insert/delete/update" and NOT "select" SQL statements? Documentation of p6spy mentions: "P6Spy allows you to monitor specific tables or specific statement types" An example they gave was the following: An example showing capture of all select statements, except th...
Hi all I'm trying to get to grips with what hibernate is doing under the hood, and I'm using p6spy as a proxy for the mysql jdbc driver so I can see what's really going to the database. I'm a little confused by the output from p6spy however - grateful for any light! The problem is this. I'm creating two new objects of class Test1, name...
When trying to spy on the jdbc connection to a hsqldb database it doesn't work. It looks like the org.hsqldb.jdbcDriver is not deregistered. ...