Implement filter for SQL debug - unify oracle and postgresql variable

Description

Hi, at the moment we have two System variables to do logging of SQL statements going to the database:
org.idempiere.db.postgresql.debug
org.idempiere.db.oracle.debug

This ticket is to improve this approach in two ways:

  • Unify both variables in just one -> org.idempiere.db.debug

  • When turning on debug sometimes the output is overwhelming and you just need to monitor a few tables, or statements, so idea is to implement org.idempiere.db.debug.filter as a regular expression filter to print the statements

For example, if I want to monitor all statements related to AD_Tree I can set these two variables in OSGi console:

To turn off debug again is simply to set:

Environment

None

Activity

Show:
Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created September 14, 2020 at 3:59 PM
Updated November 1, 2020 at 4:09 PM
Resolved September 17, 2020 at 1:03 PM