Hibernate Logging Plus

Products

• CA Release Automation - Release Operations Center (Nolio)

Issue/Introduction

The product documentation provides information for enabling Hibernate SQL Logging. This article describes how to enable both the hibernate and hibernate with bind parameter tracing (BindParameters).

Environment

Release : 6.7

Component : CA RELEASE AUTOMATION CORE

Resolution

When enabling Hibernate BindParameters tracing, be sure to:

• Adjust log file settings (for nolio_dm_all) to capture enough data. These trace settings capture a huge amount of data and will most likely need the log settings adjusted to capture more than the default. See the section How to Increase the Number of Logs Retained in the product documentation for more information. 

• Collect the logs immediately after reproducing the problem. Then disable Hibernate tracing. 

• Provide the logs and timestamp of when the problem was reproduced. 

 

Enabling hibernate+ tracing is done from the product JMX console. Where applicable, replace localhost with the Management Server/Execution Server/Agent IP/Hostname.

Component: Hibernate SQL Logging
Location: http://localhost:20203/mbean?objectname=Logging%3Atype%3DLog4j
Operation (execute to turn on/off hibernate SQL logging):

• To Enable:
  • turnOnHibernateSQLLogging
  • turnOnHibernateBindParametersLogging
• To Disable:
  • turnOffHibernateSQLLogging
  • turnOffHibernateBindParametersLogging

 

 

Additional Information

Default login/password for JMX is nolio/nolio