Tomcat JDBC Interceptors

Some interceptors for the Tomcat JDBC pool.

License	Apache 2.0
Categories	Tomcat Container Application Servers
GroupId	ch.ledcom.tomcat.interceptors
ArtifactId	tomcat-jdbc-interceptors
Last Version	0.4
Release Date	Feb 27, 2013
Type	jar
Description	Tomcat JDBC Interceptors Some interceptors for the Tomcat JDBC pool.
Project Organization	LedCom
Source Code Management	https://github.com/gehel/tomcat-jdbc-interceptors

Download tomcat-jdbc-interceptors

Filename	Size
tomcat-jdbc-interceptors-0.4.pom
tomcat-jdbc-interceptors-0.4.jar	5 KB
tomcat-jdbc-interceptors-0.4-sources.jar	3 KB
tomcat-jdbc-interceptors-0.4-javadoc.jar	22 KB

How to add to project

Apache Maven

<!-- https://jarcasting.com/artifacts/ch.ledcom.tomcat.interceptors/tomcat-jdbc-interceptors/ -->
<dependency>
    <groupId>ch.ledcom.tomcat.interceptors</groupId>
    <artifactId>tomcat-jdbc-interceptors</artifactId>
    <version>0.4</version>
</dependency>

Gradle Groovy

// https://jarcasting.com/artifacts/ch.ledcom.tomcat.interceptors/tomcat-jdbc-interceptors/
implementation 'ch.ledcom.tomcat.interceptors:tomcat-jdbc-interceptors:0.4'

Gradle Kotlin

// https://jarcasting.com/artifacts/ch.ledcom.tomcat.interceptors/tomcat-jdbc-interceptors/
implementation ("ch.ledcom.tomcat.interceptors:tomcat-jdbc-interceptors:0.4")

Apache Buildr

'ch.ledcom.tomcat.interceptors:tomcat-jdbc-interceptors:jar:0.4'

Apache Ivy

<dependency org="ch.ledcom.tomcat.interceptors" name="tomcat-jdbc-interceptors" rev="0.4">
  <artifact name="tomcat-jdbc-interceptors" type="jar" />
</dependency>

Groovy Grape

@Grapes(
@Grab(group='ch.ledcom.tomcat.interceptors', module='tomcat-jdbc-interceptors', version='0.4')
)

Scala SBT

libraryDependencies += "ch.ledcom.tomcat.interceptors" % "tomcat-jdbc-interceptors" % "0.4"

Leiningen

[ch.ledcom.tomcat.interceptors/tomcat-jdbc-interceptors "0.4"]

Dependencies

provided (1)

Group / Artifact	Type	Version
org.apache.tomcat : tomcat-jdbc	jar	7.0.37

test (2)

Group / Artifact	Type	Version
junit : junit	jar	4.11
org.hsqldb : hsqldb	jar	2.2.9

Project Modules

There are no modules declared in this project.

Tomcat interceptors

This is my attempt at a Tomcat JDBC interceptor. This interceptor will collect timing and number of calls metrics and publish them to a Statsd server.

The following parameters are required to configure the interceptor:

• hostname: the hostname of the Statsd server (for example: localhost)
• port: the port of the Statsd server (for example: 8125)
• sampleRate: to make sure we don't impact performances too badly, we only get statistics for a fraction of the requests (for example: 0.1)
• prefix: the prefix used to classify the metrics (for example: myapp.jdbc)

The interceptor can be configured as follow:

<Resource name="jdbc/TestDB"
          type="javax.sql.DataSource"
          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
          jdbcInterceptors="ch.ledcom.tomcat.interceptors.StatsdInterceptor(hostname=localhost,port=8125,sampleRate=0.1,prefix=myapplication.jdbc)"
          username="myusername"
          password="password"
          [...]
          driverClassName="com.mysql.jdbc.Driver"
          url="jdbc:mysql://localhost:3306/mysql"/>

Of course, you will need to add the jar to the Tomcat lib directory. The jar containing this interceptor can be downloaded from Maven Repo1.

Maven generated site available as GitHub pages.

Versions

Version
0.4 Feb 27, 2013
0.3 Feb 27, 2013
0.2 Feb 26, 2013
0.1 Feb 24, 2013