JarCastingSimple jdbc statistics
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 (just a demo, might be down): http://www.astraeus.nl:18100/
Screenshot:
Download:
simple-jdbc-stats-nodep-1.5.7.jar
Maven, gradle etc.
Add maven repository: https://nexus.astraeus.nl/nexus/content/groups/public
Pom:
<dependency>
<groupId>nl.astraeus</groupId>
<artifactId>simple-jdbc-stats</artifactId>
<version>1.5.7</version>
</dependency>
How to use:
Add the jar to your classpath:
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:<settings>:
(eg. jdbc:postgresql://localhost/mydb becomes: jdbc:stat::jdbc:postgresql://localhost/mydb)
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 your driver is not in there, make sure it's known before you connect to the database (eg Class.forName("<driver class name>"); )
There are some settings that can be passed in the jdbc url. There is a settings menu where you can change them at runtime and it will show you an example for your jdbc url.
Example (default values): webServerPort=18080;webServerConnections=2;numberOfQueries=2500;logStacktraces=true;formattedQueries=true