net.admin4j.jdbc.driver

Class Admin4jJdbcDriverJdk5Base

java.lang.Object

net.admin4j.jdbc.driver.Admin4jJdbcDriverJdk5Base

All Implemented Interfaces:

java.sql.Driver

Direct Known Subclasses:

Admin4jJdbcDriverJdk5, Admin4jJdbcDriverJdk7

public abstract class Admin4jJdbcDriverJdk5Base
extends java.lang.Object
implements java.sql.Driver

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

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.

Top resource intensive SQL statements can be browsed via the SqlDisplayServlet. By default, the top 50 statements are shown. This is configurable (see PropertyConfigurator)

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

This driver honors the following configuration settings (see PropertyConfigurator):

sql.nbr.retained.sql.statements sql.retention.time.in.millis

Since:

1.0

Author:

D. Ashmore

See Also:

SqlDisplayServlet, JmxServlet, net.admin4j.ui.config.PropertyConfigurator