Wrapper JDBC driver that monitors time spent inside JDBC code by thread.
JDBC driver URL:
jdbc:alterion:perf://class=<TARGET_DRIVER_CLASS>|url=<TARGET_JDBC_URL>
To get the time in millis spent inside JDBC for thread:
StopWatch.getTime()
A servlet filter that logs requests to the log (slf4j) and writes them asynchronously to the DB.
RequestLoggerFilter - logs request info to the DB
RequestLoggerFilterPerfJdbc - subclass of RequestLoggerFilter that also logs time spent in JDBC using perf-jdbc
RequestLoggerFilterPerfmon4J - subclass of RequestLoggerFilter that also logs time spent in JDBC using perfmon4j
By default, uses the "java:/comp/env/jdbc/request-logger" data-source to log to. Can be overridden with the "com.alterion.requestlogger.jdbc.datasource-jndi" system-property.
DB schemas for MS-SQL and PostgreSQL are in src/main/sql