How to find the DDL for Bamboo tables

Summary

When troubleshooting some errors, it may be helpful to find the Database Definition Language (DDL) or SQL commands that are run when building your Bamboo database.

Solution

Option 1 - DDL for startup

This will retrieve the SQL commands run during the SQL update steps in the startup process.

1. Stop Bamboo

2. Add the following line to <bamboo-install>/atlassian-bamboo/WEB-INF/classes/log4j.properties:

   1 log4j.logger.org.hibernate.SQL=TRACE

3. Start Bamboo

4. Once Bamboo has started up, run the following command on the command line:

   1 grep '\[SQL\]' <bamboo-home>/logs/atlassian-bamboo.log | grep 'alter table\|drop table\|create table' > sql.out

5. sql.out will contain the queries.

Option 2 - DDL for new install

This will retrieve the SQL commands run on install (when creating a new Bamboo database)

1. Start up a new instance with the following in <bamboo-install>/atlassian-bamboo/WEB-INF/classes/log4j.properties:

   1 log4j.logger.org.hibernate.SQL=TRACE

2. Complete the setup wizard, connecting to the desired type of database

3. Use grep or other string/regex manipulation on the generated logs:

   1 grep '\[SQL\]' <bamboo-home>/logs/atlassian-bamboo.log | grep 'alter table\|drop table\|create table' > sql.out

4. sql.out will contain the queries