java-cli-maven-ssl-postgres-procedure

Description

Creates a small database table called dog with an insert update delete after triggers. The trigger function fn_trigger calls sp_rolling_audit that remmoves old entries.

All output normally seen in a terminal will be in java-srv/log which will dump to the screen. The project may seem to hang but the logs from the container must be written to the project this can take up to 3 min.

Uses self-sign ssl.

Tech stack

• java
• maven
  • log4j
  • postgres driver

Docker stack

• alpine:edge
• postgres:alpine
• maven:3-openjdk-17

To run

sudo ./install.sh -u Creates java-srv/log

To stop

sudo ./install.sh -d Removes java-srv/log

For help

sudo ./install.sh -h

Credit

Stored procedure based on