search

angoca / log4db2

A logging utility like log4j for IBM Db2 SQL PL
https://angoca.github.io/log4db2/
BSD 2-Clause "Simplified" License
7 stars 2 forks source link

LOGGER.MODIFY_DESCENDANTS does not do its job #224

Open GITKELE opened 1 year ago

GITKELE commented 1 year ago

First of all, thanks for creating such a great utility! I'm using the latest version, 2022-06-08 1-RC.

To recreate the problem:

  1. Call GET_LOGGER twice to create 2 LOGGERs, i.e. Org.Project1.LOG1 & Org.Project1.LOG2;

  2. CONF_LOGGERS table looks like this: LOGGER_ID|NAME|PARENT_ID|LEVEL_ID 0|ROOT|(null)|3 1|Org|0|(null) 2|Project1|1|(null) 3|LOG1|2|(null) 4|LOG2|2|(null)

  3. Call MODIFY_DESCENDANTS(2,5);

  4. Nothing is changed in CONF_LOGGERS table.

angoca commented 4 months ago

Thank you for reporting the issue.

As you mentionned, this procedure is not updating the descendants under the given conditions.

As an alternative, you can execute call logadmin.register_logger('Org.Project1.LOG1', 5).