Internal Server Error - DB Order does not exist Position

[tppalani]

Hi Buddy,

Thanks for the code for learning Java with the docker container, I can be able to build the app locally, and also all the containers as up and running. you can see the below db container able to load SQL file but I'm not able to collect the orders.

DB status

{
    "status": "UP",
    "checks": [
        {
            "name": "coffee-shop",
            "status": "UP"
        },
        {
            "name": "Database connections health check",
            "status": "UP",
            "data": {
                "<default>": "UP"
            }
        }
    ]
}

Error message:

coffee-shop container
################

/ # ls -lrt
total 88
drwxr-xr-x    1 root     root          4096 Jun 17 15:27 deployments

/ # ls
bin          home         mnt          run          tmp
deployments  lib          opt          sbin         usr
dev          lib64        proc         srv          var
etc          media        root         sys

/ # cd deployments
/deployments # ls
app              lib              quarkus          quarkus-run.jar

DB container
#############
# ls -lrt
drwxrwxrwx   1 1000 1000  512 Jun  1 05:19 scripts
drwxr-xr-x   1 root root 4096 Jun 12 00:00 var
drwxr-xr-x   1 root root 4096 Jun 12 00:00 usr
drwxr-xr-x   2 root root 4096 Jun 12 00:00 srv
lrwxrwxrwx   1 root root    8 Jun 12 00:00 sbin -> usr/sbin
drwxr-xr-x   2 root root 4096 Jun 12 00:00 opt
drwxr-xr-x   2 root root 4096 Jun 12 00:00 mnt
drwxr-xr-x   2 root root 4096 Jun 12 00:00 media
lrwxrwxrwx   1 root root   10 Jun 12 00:00 libx32 -> usr/libx32
lrwxrwxrwx   1 root root    9 Jun 12 00:00 lib64 -> usr/lib64
lrwxrwxrwx   1 root root    9 Jun 12 00:00 lib32 -> usr/lib32
lrwxrwxrwx   1 root root    7 Jun 12 00:00 lib -> usr/lib
lrwxrwxrwx   1 root root    7 Jun 12 00:00 bin -> usr/bin
drwx------   1 root root 4096 Jun 14 21:09 root
drwxr-xr-x   2 root root 4096 Jun 14 21:09 docker-entrypoint-initdb.d
drwxrwxrwt   1 root root 4096 Jun 14 21:16 tmp
dr-xr-xr-x  11 root root    0 Jun 17 16:20 sys
dr-xr-xr-x 184 root root    0 Jun 17 16:20 proc
drwxr-xr-x   1 root root 4096 Jun 17 16:20 run
drwxr-xr-x   1 root root 4096 Jun 17 16:20 etc
drwxr-xr-x   5 root root  340 Jun 17 16:20 dev

# cd scripts
# ls -lrt
total 8
-rwxrwxrwx 1 1000 1000 1922 Jun  1 05:19 schema.sql
-rwxrwxrwx 1 1000 1000 1605 Jun  1 05:19 schema-load-data.sql
-rwxrwxrwx 1 1000 1000  425 Jun  1 05:19 load-data.sql