Why not wrap DataSource in a configuration?

Quick Start

implementation("com.github.gavlyukovskiy:p6spy-spring-boot-starter:${version}")

<dependency>    <groupId>com.github.gavlyukovskiy</groupId>    <artifactId>p6spy-spring-boot-starter</artifactId>    <version>${version}</version></dependency>

implementation("com.github.gavlyukovskiy:datasource-proxy-spring-boot-starter:${version}")

<dependency>    <groupId>com.github.gavlyukovskiy</groupId>    <artifactId>datasource-proxy-spring-boot-starter</artifactId>    <version>${version}</version></dependency>

implementation("com.github.gavlyukovskiy:flexy-pool-spring-boot-starter:${version}")

<dependency>    <groupId>com.github.gavlyukovskiy</groupId>    <artifactId>flexy-pool-spring-boot-starter</artifactId>    <version>${version}</version></dependency>

What if I add multiple decorators?

P6Spy

2017-06-07 21:42:08 INFO p6spy: #1496860928120 | took 0ms | statement | connection 0|SELECT NOW()2017-06-07 21:51:07 INFO p6spy: #1496861467802 | took 0ms | statement | connection 1|SELECT NOW()2017-06-07 21:51:07 INFO p6spy: #1496861467803 | took 0ms | statement | connection 2|SELECT NOW()2017-06-07 21:51:08 INFO p6spy: #1496861468806 | took 0ms | statement | connection 3|SELECT NOW()

@BeanpublicJdbcEventListenermyListener() {returnnewJdbcEventListener() {@OverridepublicvoidonAfterGetConnection(ConnectionInformationconnectionInformation,SQLExceptione) {System.out.println("got connection");        }@OverridepublicvoidonAfterConnectionClose(ConnectionInformationconnectionInformation,SQLExceptione) {System.out.println("connection closed");        }    };}

Note

Configuration below indicates al possible parameters together with their default values anddoes not need to be set explicitly

# Register P6LogFactory to log JDBC eventsdecorator.datasource.p6spy.enable-logging=true# Use com.p6spy.engine.spy.appender.MultiLineFormat instead of com.p6spy.engine.spy.appender.SingleLineFormatdecorator.datasource.p6spy.multiline=true# Use logging for default listeners [slf4j, sysout, file, custom]decorator.datasource.p6spy.logging=slf4j# Log file to use (only with logging=file)decorator.datasource.p6spy.log-file=spy.log# Class file to use (only with logging=custom). The class must implement com.p6spy.engine.spy.appender.FormattedLoggerdecorator.datasource.p6spy.custom-appender-class=my.custom.LoggerClass# Custom log format, if specified com.p6spy.engine.spy.appender.CustomLineFormat will be used with this log format# see https://p6spy.readthedocs.io/en/latest/configandusage.html#customlogmessageformatdecorator.datasource.p6spy.log-format=# Use regex pattern to filter log messages. If specified only matched messages will be logged.decorator.datasource.p6spy.log-filter.pattern=# Exclude certain categories from logging. If specified only matched messages will be logged.# see https://p6spy.readthedocs.io/en/latest/configandusage.html#excludecategoriesdecorator.datasource.p6spy.exclude-categories=

Datasource Proxy

2017-06-07 21:58:06 DEBUG n.t.d.l.l.SLF4JQueryLoggingListener:Name:, Time:0, Success:TrueType:Statement, Batch:False, QuerySize:1, BatchSize:0Query:["SELECT NOW()"]Params:[]2017-06-07 21:58:06 DEBUG n.t.d.l.l.SLF4JQueryLoggingListener:Name:, Time:0, Success:TrueType:Statement, Batch:False, QuerySize:1, BatchSize:0Query:["SELECT NOW()"]Params:[]2017-06-07 21:58:06.630  DEBUG 8492 --- [ool-1-worker-50] n.t.d.l.l.SLF4JQueryLoggingListener      :Name:, Time:0, Success:TrueType:Statement, Batch:False, QuerySize:1, BatchSize:0Query:["SELECT NOW()"]Params:[]2017-06-07 22:10:50 WARN n.t.d.l.logging.SLF4JSlowQueryListener:Name:, Time:0, Success:FalseType:Statement, Batch:False, QuerySize:1, BatchSize:0Query:["SELECT SLEEP(301000)"]Params:[]

@BeanpublicQueryExecutionListenerqueryExecutionListener() {returnnewQueryExecutionListener() {@OverridepublicvoidbeforeQuery(ExecutionInfoexecInfo,List<QueryInfo>queryInfoList) {System.out.println("beforeQuery");        }@OverridepublicvoidafterQuery(ExecutionInfoexecInfo,List<QueryInfo>queryInfoList) {System.out.println("afterQuery");        }    };}@BeanpublicParameterTransformerparameterTransformer() {returnnewMyParameterTransformer();}@BeanpublicQueryTransformerqueryTransformer() {returnnewMyQueryTransformer();}@BeanpublicConnectionIdManagerProviderconnectionIdManagerProvider() {returnMyConnectionIdManager::new;}

Note

Configuration below indicates all possible parameters together with their default values anddoes not need to be set explicitly

# One of logging libraries (slf4j, jul, common, sysout)decorator.datasource.datasource-proxy.logging=slf4jdecorator.datasource.datasource-proxy.query.enable-logging=truedecorator.datasource.datasource-proxy.query.log-level=debug# Logger name to log all queries, default depends on chosen logging, e.g. net.ttddyy.dsproxy.listener.logging.SLF4JQueryLoggingListenerdecorator.datasource.datasource-proxy.query.logger-name=decorator.datasource.datasource-proxy.slow-query.enable-logging=truedecorator.datasource.datasource-proxy.slow-query.log-level=warndecorator.datasource.datasource-proxy.slow-query.logger-name=# Number of seconds to consider query as slow and log itdecorator.datasource.datasource-proxy.slow-query.threshold=300decorator.datasource.datasource-proxy.multiline=true# Formats the SQL for better readability. Uses Hibernate's formatter if present on the class path. If you opted in for a different JPA provider you need to add https://github.com/vertical-blank/sql-formatter as a runtime dependency to your app  to enable this.# Mutually exclusive with json-format=truedecorator.datasource.datasource-proxy.format-sql=falsedecorator.datasource.datasource-proxy.json-format=false# Enable Query Metricsdecorator.datasource.datasource-proxy.count-query=false

@BeanpublicLoggingFilterloggingFilter() {returnMyLoggingFilter();}

Flexy Pool

Important

If you are not relying on Spring Boot autoconfiguration and instead declare a customDataSource bean, you need to usea concreteDataSource type as the return value (e.g.,@Bean HikariDataSource dataSource()) to match the FlexyPool adapter.

2017-07-13 01:31:02 INFO c.v.flexypool.FlexyPoolDataSource: Connection leased for 1500 millis, while threshold is set to 1000 in dataSource FlexyPoolDataSource2017-07-13 01:31:03 WARN PoolOnTimeoutConnectionAcquisitionStrategy: Connection was acquired in 1502 millis, timeoutMillis is set to 5002017-07-13 01:31:03 INFO PoolOnTimeoutConnectionAcquisitionStrategy: Pool size changed from previous value 10 to 11

Note

Configuration below indicates al possible parameters together with their default values anddoes not need to be set explicitly

# Increments pool size if connection acquisition request has timed outdecorator.datasource.flexy-pool.acquisition-strategy.increment-pool.max-overgrow-pool-size=15decorator.datasource.flexy-pool.acquisition-strategy.increment-pool.timeout-millis=500# Retries on getting connectiondecorator.datasource.flexy-pool.acquisition-strategy.retry.attempts=2# Enable metrics exporting to the JMXdecorator.datasource.flexy-pool.metrics.reporter.jmx.enabled=truedecorator.datasource.flexy-pool.metrics.reporter.jmx.auto-start=false# Millis between two consecutive log reportsdecorator.datasource.flexy-pool.metrics.reporter.log.millis=300000# Enable logging and publishing ConnectionAcquisitionTimeThresholdExceededEvent when a connection acquisition request has timed outdecorator.datasource.flexy-pool.threshold.connection.acquisition=50# Enable logging and publishing ConnectionLeaseTimeThresholdExceededEvent when a connection lease has exceeded the given time thresholddecorator.datasource.flexy-pool.threshold.connection.lease=1000

Spring Cloud Sleuth (removed since 1.9.0)

For Spring Boot users, that DO NOT use Spring Cloud Sleuth

For Spring Cloud Sleuth users

Migration process:

Custom Decorators

@BeanpublicDataSourceDecoratorcustomDecorator() {return (beanName,dataSource) ->newDataSourceWrapper(dataSource);}

Disable Decorating