Craftsman Spy is a an open source and free framework for JDBC logging. Craftsman Spy is a JDBC driver implementation.
This logger logs all SQL connection and processings with execution spent time, all the stored procedures with arguments, all the batch processings and the result sets.
No need to modify your application in order to integrate JDBC logging with Craftsman Spy. The application MUST use the craftsman.spy.SpyDriver and MUST be launched with the -Dspy.driver=... system property.
Be carefull this JDBC driver SHOULD not be used in production mode. Use it only in development or pre-production system.
The two solutions can be used as the following examples :
System.setProperty("spy.driver","vendor.database.Driver");// or with the -Dspy.driver=vendor.database.Driver JVM option
Connection c = DriverManager.getConnection("jdbc:database:mydata");
Connection c = DriverManager.getConnection("jdbc:spy:vendor.database.Driver:database:mydata");
The log4j.properties or log4j.xml configuration file SHOULD contain the following lines :
· commons logging 1.0.4
· log4j 1.2.11
What's New in This Release:
· The clearing and the reuse of prepared statements were fixed for better support of JDBC pools.
· Batch registering and logging were secured and optimized.
· More control was added and fatal messages are now logged.