Supported Databases by Active Objects ORM:
- Aurora / MySQL / MariaDB
- PostgreSQL
Here for demo we will use MySQL Database commands to setup SCM Activity Database:
Create Scm Activity Database.
| Code Block |
|---|
CREATE DATABASE IF NOT EXISTS scmactivity character set utf8; |
Create Database user credentials with permissions.
| Code Block |
|---|
CREATE USER 'scmactivity'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON scmactivity.* TO 'scmactivity'@'%';
FLUSH PRIVILEGES; |
Configure SCM Activity JDBC Connection.
| Status |
|---|
| |
|---|
| colour | Blue |
|---|
| title | Aurora / Mysql / MariaDB |
|---|
|
| Code Block |
|---|
jdbc:mariadb://localhost/scmactivity
//use this for unicode character encoding
jdbc:mariadb://localhost/scmactivity?useUnicode=yes&characterEncoding=UTF-8 |
| Status |
|---|
| |
|---|
| colour | Blue |
|---|
| title | PostgreSQL |
|---|
|
| Code Block |
|---|
jdbc:postgresql://localhost:5432/scmactivity |