Hi Guys!
I wonder if there is possibility to configure my plugin project to use external database. I mean not to join external data but setup dev environment on external database. Jira 10 ends with h2 compatibility and i’m searching for alternatives.
1 Like
Hi @JacekOstrowski2 and welcome to the community!
Yes, it’s definitely possible to configure your Jira development environment to use an external database. Since Jira 10 has ended H2 compatibility, you’ll need to set up an external database for your development environment2. Here are the general steps to do this:
- Choose a Database: Select an external database that is supported by Jira, such as PostgreSQL, MySQL, Oracle, or SQL Server.
- Set Up the Database: Install and configure the chosen database on your development machine.
- Configure Jira to Use the External Database: You’ll need to create a
dbconfig.xml
file in your Jira home directory. This file will define the database connection details1.
- Update Environment Variables: Set the necessary environment variables to point to your external database.
Here’s a sample dbconfig.xml
file for PostgreSQL:
<connection-url>jdbc:postgresql://localhost:5432/jira</connection-url>
<database-name>jira</database-name>
<database-user>your_username</database-user>
<database-password>your_password</database-password>
<driver-class>org.postgresql.Driver</driver-class>
- Run Jira with Atlas-Run: Use the
atlas-run
command to start your Jira instance with the external database configuration.
Maybe this helps
Cheers,
Daniel