Package net.admin4j.jdbc.driver

Proxy JDBC driver that allows JMX view into JDBC connection content and tracks SQL statement performance.

See: Description

Interface Summary

Interface	Description
Admin4jJdbcJmx	Exposes Driver info via the JMX Console
DriverContext	Describes underlying JDBC driver in use.

Class Summary

Class	Description
Admin4jJdbcDriverJdk5	Wraps a JDBC V4.0 driver so specifics can be reported to administrators.
Admin4jJdbcDriverJdk5Base	Proxy JDBC driver that allows JMX view into JDBC connection content and tracks SQL statement performance.
Admin4jJdbcDriverJdk7	Jdk 7 proxy for JDBC driver that allows view into JDBC connection content.
Admin4jJdbcJmxMBean	Exposes Driver info via the JMX Console
Admin4jJdbcJmxMBean.ConnectionInfo
Admin4jJdbcJmxMBean.StatementInfo
ConnectionRegistry	Keeps track of all active connections.
DriverContextImpl	Default implementation of a DriverContext
DriverContextRegistry	Registry for JDBC drivers that are currently being proxied.
SqlStatementSummaryDataMeasure	Tracks timing statistics for a SQL statement
SqlStatementTimerFactory	Tracks SQL Statement timers that have been issued.
SqlTaskTimer	Times SQL Statement executions.

Package net.admin4j.jdbc.driver Description

Proxy JDBC driver that allows JMX view into JDBC connection content and tracks SQL statement performance.

This JDBC driver will do the following:

Automatically time all SQL Statement executions. The top 50 Statements (by default) are browsable via the SqlDisplayServlet. This is configurable (see net.admin4j.config.PropertyConfigurator)

Connection activity is also viewable via JMX or via the JmxServlet.

Depending on the runtime version of Java you're using, the specific driver class to use is the following (all package net.admin4j.jdbc.driver):

Java V1.5x - Admin4jJdbcDriverJdk5

Java V1.6x - Admin4jJdbcDriverJdk5

Java V1.7x - Admin4jJdbcDriverJdk7

The connection URL for this driver is in the following format:

        jdbcx:admin4j:[admin4J properties]::[underlying driver URL]

For example:

        jdbcx:admin4j:driver=org.hsqldb.jdbcDriver,poolName=mainPoolDB::jdbc:hsqldb:mem:Admin4JTestDb

Supported Admin4J driver properties are the following:

driver - Required. Class name of the underlying JDBC driver

poolName - Optional. Default none. Name of the connection pool to which this driver is being assigned. This is displayed with performance metrics.

stackTrace - Optional (true/false). Default true. Specifies if execution stack traces are tracked so you know where in your code a SQL statement is being executed. Tests show setting to false will save approximately 1 millisecond per seven SQL Statement executions.

This driver honors the following configuration settings (see net.admin4j.config.PropertyConfigurator):

sql.nbr.retained.sql.statements

sql.retention.time.in.millis