sakila VS spring-petclinic

FROM yugabytedb/yugabyte:latest # get Sakila DDL and DML scripts ADD https://github.com/jOOQ/sakila/raw/main/yugabytedb-sakila-db/yugabytedb-sakila-schema.sql . ADD https://github.com/jOOQ/sakila/raw/main/yugabytedb-sakila-db/yugabytedb-sakila-insert-data.sql . # Start YugabyteDB to run the scripts RUN yugabyted start \ && until ysqlsh -h $(hostname) -c "create database sakila" ; do sleep 1 ; done | uniq \ && ysqlsh -h $(hostname) -d sakila -f yugabytedb-sakila-schema.sql \ && ysqlsh -h $(hostname) -d sakila -f yugabytedb-sakila-insert-data.sql \ && yugabyted stop \ && rm -f /root/var/data/yb-data/*/wals/table-*/tablet-*/index.* # starting a container can re-start YugabyteDB ENTRYPOINT yugabyted start --background=false

The script only contains INSERT statements, you apparently did not create the table and sequences before you ran that script. You need to run the script to create the schema first: https://github.com/jOOQ/sakila/blob/main/postgres-sakila-db/postgres-sakila-schema.sql

Then downloading the database https://github.com/jOOQ/sakila (has a ERD to help you write your queries as well)

Here is a good repository to look at as you make progress. Good luck!

I like Spring's petclinic https://github.com/spring-projects/spring-petclinic

For the sake of demonstration, I'm going to use the same project I've used in my post about Omnipytent - the Java Sprint example project PetClinic.

"The Spring Pet Clinic" is well explained and obviously well designed and coded as an official Spring projet : https://github.com/spring-projects/spring-petclinic

For this OpenTelemetry Java example, we’ll be using the Spring Pet Clinic project, to save you some time setting up an example project.