How to run SQL commands in a HSQL database?

[Michał Gawlik]

Hi,

I am using JIRA 6.3.5 and here is description how to do it:
https://confluence.atlassian.com/display/JIRA/Running+SQL+commands+in+a+HSQL+database"

but  I cannot see "$JIRA_HOME/database" directory.

I only have these:

jira\home>ls
analytics-logs data database.log database.script export log monitor
caches database.lck database.properties dbconfig.xml import logos plugins

Thank you in advance for help

Michal

[Nic Brough -Adaptavist- · Accepted solution]

You're in the right place, but using a different hsql implementation (it varies if you've used EAR/WAR, the installer, the plain download-and-unpack, built it yourself, or running from the SDK).

Where it says look in $JIRA_HOME/database, you just need to read it as $JIRA_HOME

[Michał Gawlik]

Thanks Nic, it works!