Troubleshooting SQL Exceptions - Detailed Hibernate Logging

This document outlines the steps to take to increasing logging on your system.

1. Open <bamboo-install>/webapp/WEB-INF/classes/log4j.properties and add/change the following lines. The double ## lines are comments, leave them intact.

   ## log hibernate prepared statements/SQL queries (equivalent to setting 'hibernate.show_sql' to 'true')
   log4j.logger.net.sf.hibernate.SQL=DEBUG
   log4j.additivity.net.sf.hibernate.SQL=false
   
   ## log hibernate prepared statement parameter values
   log4j.logger.net.sf.hibernate.type=DEBUG
   log4j.additivity.net.sf.hibernate.type=false
   

   If you can not locate these lines in your log4j.properties file, please add them to the end of it.
2. Restart bamboo.
3. Redo the steps that led to the error.
4. Zip up your logs directory and attach it your support ticket.