Setup Scm Activity Database

Owned by ILA eSolution
Last updated: Oct 28, 2020

Supported Databases by Active Objects ORM:

  • Aurora / MySQL / MariaDB
  • PostgreSQL (recommended)


Here for demo we will use MySQL Database commands to setup SCM Activity Database:

STEP-1

Create Scm Activity Database.

CREATE DATABASE IF NOT EXISTS scmactivity character set utf8;


STEP-2

Create Database user credentials with permissions.

CREATE USER 'scmactivity'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON scmactivity.* TO 'scmactivity'@'%';
FLUSH PRIVILEGES;


STEP-3

Configure SCM Activity JDBC Connection.


AURORA / MYSQL / MARIADB

jdbc:mariadb://localhost/scmactivity

//use this for unicode character encoding
jdbc:mariadb://localhost/scmactivity?useUnicode=yes&characterEncoding=UTF-8


POSTGRESQL

jdbc:postgresql://localhost:5432/scmactivity