Jump to Real's How-to Main page

Log the SQL Statements

Plain JDBC Logging

See this HowTo.

P6Spy

P6Spy is an open source framework for applications that intercept and optionally modify database statements.

The log file format is 

current time|execution time|category|statement SQL String|effective SQL string
P6Spy is especially useful with an application server.

Download at http://p6spy.com/

Proxool

Proxool is a Java connection pool.

It provides really nice logging facilities with the SQL statement and the running time.

Download at http://proxool.sourceforge.net/

If you find this article useful, consider making a small donation
to show your support for this Web site and its content.

Written and compiled by Réal Gagnon ©1998-2008
[ home ]