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

Assignee

Carlos Ruiz

Reporter

Carlos Ruiz

Labels

None

Tested By

None

Fix versions

Priority

Major
Configure