rnentjes authored on 18 Mar 2017
.idea Update version to 1.6.8-SNAPSHOT 7 years ago
conf Added missing build config files 11 years ago
data Update screenshot 7 years ago
dist Latest dist.zip 10 years ago
gradle/ wrapper Build settings 7 years ago
script Use gradle build 8 years ago
src/nl/astraeus/ jdbc Release 1.5.7 7 years ago
test/nl/astraeus/ jdbc Bootstrap 3, use cdn 7 years ago
.gitignore Use gradle build 8 years ago
LICENCE.txt Small changes, added MIT licence 11 years ago
Simple-jdbc-statistics.iml Update build version 9 years ago
build.gradle Update version to 1.6.8-SNAPSHOT 7 years ago
gradlew Build settings 7 years ago
gradlew.bat Build settings 7 years ago
readme.md Update readme.md 7 years ago
settings.gradle Use gradle build 8 years ago
simple-web.iml New version 7 years ago
readme.md

Simple 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:

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