Problem

Jira uses a number of different ORM / library to write and execute SQL query. To enable debug, originally Jira shipped with a "SQL Logging" feature, quick provided an "enable/disable" toggle. This toggle write SQL query to atlassian-jira-sql.log file for any query executed with ofbiz

Queries executed with other libraries will take no effect for this setting.

• ActiveObjects - used by Jira and third party plugins
• QueryDSL - used by Atlassian and third party plugins, for example, Advanced Roadmaps for Jira (formerly Portfolio)

The user has to know these package names and add them manually into the Add another package screen

Suggested Solution

Improve the SQL Debug options to include

•  [  ] SQL Logging (ofbiz)
•  [  ] SQL Trace Logging (ofbiz)
•  [  ] ActiveObjects SQL logging
•  [  ] QueryDSL logging

Write these out into individual logs:

• ofbiz - atlassian-jira-sql.log
• querydsl - atlassian-jira-sql-querydsl.log
  • com.querydsl.sql
• ActiveObjects - atlassian-jira-sql-ao.log
  • net.java.ao.sql