How to Enable SQL Logging in Crowd
To enable detailed SQL logging in Crowd, you need to modify
log4j.properties, located in
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
## 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=TRACE