/
Setup Scm Activity Database

Setup Scm Activity Database

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