DEBUGGING YOUR SQLs WITH A JDBC DRIVER

• Download the SQL Spy from http://sozlux.org/download/p6spy-install.zip.
• Extract the file and copy the spy.properties and spy.jar files to your TOMCAT_HOME/lib directory.
• Edit spy.properties directory and change the real driver to your original driver on the following line

realdriver=com.mysql.jdbc.Driver

• Edit your connection pool settings and use now this driver as your jdbc driver

com.p6spy.engine.spy.P6SpyDriver