On this page:
Before you begin
1. Copy the HSQLDB driver to your application server
- Download the HSQLDB JDBC driver — hsqldb-126.96.36.199.jar for JIRA 3.7+, or hsqldb-1.7.1-patched.jar for JIRA 3.6.5 and earlier. We strongly recommend upgrading to 3.7 if you wish to use hsqldb, as hsqldb 1.7.x is prone to data corruption.
- Add the HSQLDB JDBC driver jar to the
2. Configure your application server to connect to HSQLDB
conf/server.xml(if you are using JIRA Standalone) and customise the
timeBetweenEvictionRunsMillisparameters for the Datasource. (If you are using JIRA WAR/EAR, edit the appropriate file on your application server; e.g. for Tomcat, edit
conf/Catalina/localhost/jira.xml.) (Note: if you can't find this section at all, you've probably got the wrong file - search for mentions of 'jira' in the files under
4. Configure the JIRA Entity Engine
atlassian-jira/WEB-INF/classes/entityengine.xml(if you are using JIRA Standalone) or
edit-webapp/WEB-INF/classes/entityengine.xml(JIRA WAR/EAR), and change the
hsql. (If you forget to do this and start JIRA, it may create database tables incorrectly. See this page if this happens to you).
You should now have an application server configured to connect to a database, and JIRA configured to use the correct database type. If you are using JIRA Standalone, start it up and watch the logs for any errors. If you are using the JIRA WAR/EAR distribution, rebuild and redeploy the webapp in your application server.
Have experiences to share with HSQL and JIRA? We welcome your thoughts. Please see the user-contributed HSQL notes.