Craftsman Spy Craftsman Spy is a framework for JDBC logging.
Download

Craftsman Spy Ranking & Summary

Craftsman Spy Tags

JDBC Spy JDBC logging JDBC framework JDBC driver implementation Craftsman

Craftsman Spy Description

Craftsman Spy is a framework for JDBC logging. 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.,b>Usage:CodeThe 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 optionClass.forName("craftsman.spy.SpyDriver");Connection c = DriverManager.getConnection("jdbc:database:mydata");Class.forName("craftsman.spy.SpyDriver");Connection c = DriverManager.getConnection("jdbc:spy:vendor.database.Driver:database:mydata");Log configurationThe log4j.properties or log4j.xml configuration file SHOULD contain the following lines : log4j.category.craftsman.spy=DEBUG, SpyFilelog4j.appender.SpyFile=org.apache.log4j.DailyRollingFileAppenderlog4j.appender.SpyFile.DatePattern='.'yyyy.MM.ddlog4j.appender.SpyFile.File=spy.loglog4j.appender.SpyFile.layout=org.apache.log4j.PatternLayoutlog4j.appender.SpyFile.layout.ConversionPattern=%m%nRequirements:· commons logging 1.0.4· log4j 1.2.11What'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.

Craftsman Spy Related Software