Creates a small database table
called dog and populates with
hql. Creates 2 lookup tables breedLookup
and colorLookup and 4N dog.
Joins breedLookup and colorLookup
to form a new table dogextended. These
views are deministrated 3 ways, ResultTransformer,
looking up ids on breedLookup and colorLookup,
and non-ResultTransformer method.
Add an immutable entity breedcount as a view uses a subquery join.
A groovy maven build, that connects to single node cockroach database without ssl.
- groovy
- maven
- hibernate
- hql
- log4j
- postgres drivers
- cockroachdb/cockroach:v19.2.2
- maven:3-openjdk-17
sudo ./install.sh -u
sudo ./install.sh -d
sudo ./install.sh -h