Filtering logs with datasource-proxy

[ellebrecht]

Using datasource-proxy, is there any way to filter statements from being logged via net.ttddyy.dsproxy.listener.logging.SLF4JQueryLoggingListener?

datasource-proxy seems to offer some programmatic way for filtering, it is unclear however how this is to be used with spring-boot-data-source-decorator autoconfiguration.

[gavlyukovskiy]

datasource-proxy seems to offer some programmatic way for filtering

@ellebrecht can you please share a link to docs that offers such filtering? If that's possible to programmatically set on the datasource / listener level, then I can look into adding support for that

[ellebrecht]

Filtering (e.g. based on regex) can be done e.g. through Slf4jQueryLoggingListener. Either through extending it and filtering logs in writeLog(), or by using setQueryLogEntryCreator() to set a QueryLogEntryCreator that filters in its getLogEntry() method.
Hope this helps.

[gavlyukovskiy]

@ellebrecht you can extend SLF4JQueryLoggingListener and declare it as a Spring bean, this way it will be added to the ProxyDataSource. Just remove all the properties related to logging, so that you don't get duplicate logs