Oracle Persistence Updated Models

Release Detail

• Feature
• Build related changes
• Other (please describe): Docker / Docker Compose files included.

Feature

1. Oracle Persistence / Option to use Oracle Database as persistence unit.
2. Docker Compose example with Oracle Container.

Technical Note

1. Utilizes Oracle Database version 11G for Unit Tests

Due to GuitHub GI Container disk space limitation, no version > 11G can be used for Unit Tests.
Can be easily upgraded to 18 XE or 19C Enterprise once GitHub Action updates size capacity which they are apparantly working on).

2. Due to a technical version dependency, spring.flyway.locations cannot be automatically set to db/migration_oracle (similar to postgres-persistence) and has to be set through .properties file while running the jar along with conductor.db.type

Refer to docker/server/config-oracle.properties for example

3. Flyway 6.4.4 (5.2+) - Only compatible with Oracle 12.2+
4. Flyway 4.0.3 (<5.2) - Used for Unit Tests as Oracle 11G XE is used for Oracle Container.

Mongo Persistence

Release Details

• Feature
• Build related changes
• Other (please describe): Docker / Docker Compose files included.

Changes in this Release

1. Mongo Persistence / Option to use Mongo Database as persistence unit.
2. Docker Compose example with Mongo Container.

Alternatives considered

Many other persistence alternatives like Cassandra, MySQL, Postgres already exist. This is just an addition to persistence options.

API Security - OAuth2 Role Based Security

Release Detail

• Feature
• Other (please describe): Community Contribution

Changes in this PR

OAuth 2.0 Role Based Security.
Docker Compose Secure Set-Up example.
Check SECURITY.md for more details.

Alternatives considered

No alternatives available other than securing the Jar hosting container (Docker) or host.

Oracle Persistence

Release Detail

• Feature
• Build related changes
• Other (please describe): Docker / Docker Compose files included.

Feature

1. Oracle Persistence / Option to use Oracle Database as persistence unit.
2. Docker Compose example with Oracle Container.

Technical Note

1. Utilizes Oracle Database version 11G for Unit Tests

Due to GuitHub GI Container disk space limitation, no version > 11G can be used for Unit Tests.
Can be easily upgraded to 18 XE or 19C Enterprise once GitHub Action updates size capacity which they are apparantly working on).

2. Due to a technical version dependency, spring.flyway.locations cannot be automatically set to db/migration_oracle (similar to postgres-persistence) and has to be set through .properties file while running the jar along with conductor.db.type

Refer to docker/server/config-oracle.properties for example

3. Flyway 6.4.4 (5.2+) - Only compatible with Oracle 12.2+
4. Flyway 4.0.3 (<5.2) - Used for Unit Tests as Oracle 11G XE is used for Oracle Container.