Use the logger-db-query script to enable or disable logging for queries. Once enabled, the database queries along with the query parameters are logged in
However, the log level change is persistent and can survive Jboss restart. This means that you have to disable logging after the diagnosis or debug work is complete. Continuous logging can impact the performance.
Use the following command to run this script.
[RUNTIME_DIR]/scripts/logger-db-query [[--enable|-e] | [--disable|-d] | [--help|-h]
|-e | –enable||Enable logging.|
|-d | –disable||Disable logging.|
|-h | –help||To view help information for the script.|