Simple demo application that demonstrates usage of db and java

Program in Java language that is processing commands from FIFO queue using Producer – Consumer pattern. Supported commands are the following:

• Add - adds a user into a database
• PrintAll – prints all users into standard output
• DeleteAll – deletes all users from database

User is defined as database table "SUSERS"

• "USER_ID": integer
• "USER_GUID": string
• "USER_NAME": string

This project uses:

• Java 17
• Maven
• In memory H2 database
• Hibernate

Make sure to have installed

Git

JDK 17 or later

Maven 3.8.8 or later

DB Structure

During unit tests, this project uses simple in memory H2 database with initial SQL script for schema creation.

SQL Script used for table cration

Build & Test:

mvn clean install