A simple wrapper around jdbc drivers that will show some statistics about the running queries on a simple web page on port 18080.
See a running example here:
http://phoibe.astraeus.nl:18080/
To use:
Add the following jars to your classpath:
Add the following jar if you are not running in a web container:
Set your jdbc driver property to the following class:
nl.astraeus.jdbc.Driver
Add the following to the front of your current jdbc url:
jdbc:stat: (eg. jdbc:postgresql://localhost/mydb becomes: jdbc:stat:jdbc:postgresql://localhost/mydb)
If you want a login screen add the following instead:
jdbc:secstat:
Use the credentials in your jdbc properties to login
Start your application and goto: http://<host app is running on>:18080/
You will see an overview of the last 2500 queries run on your database and some timing stats about them.
Drivers automatically discovered atm:
org.postgresql.Driver oracle.jdbc.driver.OracleDriver com.sybase.jdbc2.jdbc.SybDriver net.sourceforge.jtds.jdbc.Driver com.microsoft.jdbc.sqlserver.SQLServerDriver com.microsoft.sqlserver.jdbc.SQLServerDriver weblogic.jdbc.sqlserver.SQLServerDriver com.informix.jdbc.IfxDriver org.apache.derby.jdbc.ClientDriver org.apache.derby.jdbc.EmbeddedDriver com.mysql.jdbc.Driver org.hsqldb.jdbcDriver org.h2.Driver
If yours driver is not in there, make sure it's known before you connect to the database (eg Class.forName("<driver class name>"); )