How to Enable SQL Logging in Crowd

Still need help?

The Atlassian Community is here for you.

Ask the community

To enable detailed SQL logging in Crowd, you need to modify, 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 file:

    ## Log hibernate prepared statements/SQL queries (equivalent to setting 'hibernate.show_sql' to 'true')
  3. Start Crowd

Last modified on Feb 11, 2015

Was this helpful?

Provide feedback about this article
Powered by Confluence and Scroll Viewport.