Supported Databases
Here for demo we will use MySQL Database commands for the steps 1 and 2. Note. for SQ Lite skip steps 1 and 2:
Create Scm Activity Database.
CREATE DATABASE IF NOT EXISTS scmactivity character set utf8; |
Create Database user credentials with permissions.
GRANT ALL PRIVILEGES ON scmactivity.* TO scmactivity@'localhost' IDENTIFIED BY 'secret'; FLUSH PRIVILEGES; |
Configure SCM Activity JDBC Connection.
SQLite is very simple - You can keep Database file in Jira Home directory and that's it! :-)
jdbc:sqlite:C:/APPS/sqlitedb/SCMActivity.db org.sqlite.JDBC |
(C:/APPS/sqlitedb/SCMActivity.db) is system database file path.
jdbc:mysql://localhost/scmactivity com.mysql.jdbc.Driver |
jdbc:jtds:sqlserver://localhost:1433/scmactivity net.sourceforge.jtds.jdbc.Driver |
jdbc:postgresql://localhost:5432/scmactivity org.postgresql.Driver |