Setup Scm Activity Database (Legacy)

Owned by ILA eSolution
Last updated: May 10, 2019

Supported Databases

  • Microsoft SQL Server
  • PostgreSQL
  • MySQL
  • SQLite


Here for demo we will use MySQL Database commands for the steps 1 and 2. Note. for SQ Lite skip steps 1 and 2:

STEP-1

Create Scm Activity Database.

CREATE DATABASE IF NOT EXISTS scmactivity character set utf8;


STEP-2

Create Database user credentials with permissions.

GRANT ALL PRIVILEGES ON scmactivity.* TO scmactivity@'localhost' IDENTIFIED BY 'secret';
FLUSH PRIVILEGES;


STEP-3

Configure SCM Activity JDBC Connection.


SQLITE

SQLite is very simple - You can keep Database file in Jira Home directory and that's it! :-)

SQLite Database Config

jdbc:sqlite:C:/APPS/sqlitedb/SCMActivity.db
org.sqlite.JDBC

(C:/APPS/sqlitedb/SCMActivity.db) is system database file path.


MYSQL

MySQL Database Config

jdbc:mysql://localhost/scmactivity
com.mysql.jdbc.Driver


MICROSOFT SQL SERVER

jdbc:jtds:sqlserver://localhost:1433/scmactivity
net.sourceforge.jtds.jdbc.Driver


POSTGRESQL

jdbc:postgresql://localhost:5432/scmactivity
org.postgresql.Driver