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

[ellebrecht]

Thanks for your response. Unfortunately, I can't see a solution this way. You recommend to provide a separate SLF4JQueryLoggingListener bean. Even if this is attached as an additional listener, this does not solve the problem of filtering log entries.

A SLF4JQueryLoggingListener together with a QueryLogEntryCreator is attached in ProxyDataSourceBuilder.buildProxyConfig(). I can see no way to configure those newly created objects. So I cannot implement filtering there. Whatever additional listener bean I provide I can implement filtering in, it does not influence the first listener which will still log the entries that are supposed to be filtered out, right?

[frederikb]

@ellebrecht I recently contributed query logging filtering upstream and proposed support for it via #149. Perhaps this would cover your usecase as welll?

[ellebrecht]

Excellent, this looks great! You already released it. Will definitely check it out.