How to Enable SQL Logging in Crowd

Related content

  • No related content found

Still need help?

The Atlassian Community is here for you.

Ask the community

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

  1. Stop Crowd

  2. Add the following lines to the end of the log4j.properties file:

    ## 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

  3. Start Crowd

Last modified on Feb 11, 2015

Was this helpful?

Yes
No
Provide feedback about this article

Related content

  • No related content found
Powered by Confluence and Scroll Viewport.