How to Enable SQL Logging in Crowd
To enable detailed SQL logging in Crowd, you need to modify log4j.properties, located in <crowd-installation-directory>/crowd-webapp/WEB-INF/classes.
If you require support assistance with a database-related problem, it is advisable to enable detailed SQL logging before sending us the log files. This will assist us in determining what SQL queries were running during the reported problem.
To Log SQL Queries with Parameters
- Stop Crowd
Add the following lines to the end of the
log4j.propertiesfile:## Log hibernate prepared statements/SQL queries (equivalent to setting 'hibernate.show_sql' to 'true') log4j.logger.org.hibernate.SQL=DEBUG log4j.logger.org.hibernate.type=TRACE log4j.appender.crowdlog.Threshold=TRACEStart Crowd
最終更新日: 2015 年 2 月 11 日
Powered by Confluence and Scroll Viewport.