View Source

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:

Create Scm Activity Database.

CREATE DATABASE IF NOT EXISTS scmactivity character set utf8;

Create Database user credentials with permissions.

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

Configure SCM Activity JDBC Connection.

jdbc:mariadb://localhost/scmactivity

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

jdbc:postgresql://localhost:5432/scmactivity