And yes it will capture your SQL
Here is some of our output in our console
p6spy - 1196689443367|0|2|statement||select * from sysibm.SYSDUMMY1
-Original Message-
From: Tom Henricksen [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 7:42 AM
To: user-java@ibatis.apache.org
P6spy is pretty easy to setup.
http://www.p6spy.com/documentation/index.htm
from what I remember you basically point your system to there driver
driver=com.p6spy.engine.spy.P6SpyDriver
Then setup the spy.properties to point to your drvier.
# ibm db2 driver
# realdriver=COM.i