This is a Java project that imports data from a Excel file.
Create a Spring Boot project that reads a Excel file (SGT/CNJ) and import all data (e.g. motions data) into a Postgres database and generate load data scripts and/or reports.
https://www.cnj.jus.br/sgt/versoes.php?tipo_tabela=A
Do the next procedments every time you recreate database volume.
bscpaz@2am:/$ docker exec -it sgt-db bash
bash-5.1# su postgres
/$ psql
postgres=# \password postgres
Enter new password: <new-password>
postgres=# \q
Open remote project [WSL:Ubuntu-18.04] in "/home/tr***/workspace/sgt-import" path
bscpaz@2am:/$ docker start sgt-db
Issue:
"Could not change permissions of directory "/var/lib/postgresql/data": Operation not permitted"
Solution:
Do not map the volume pointing to a Windows path. Instead, map to a WSL2 directory, like /var/lib/docker/volumes.
e.g.: /var/lib/docker/volumes/postgresql/data
Issue:
"ERROR [internal] load metadata for docker.io/library/postgres:14.0-alpine ".
"failed to create LLB definition: rpc error"
Solution:
Docker desktop -> Settings -> Docker Engine -> Change the "features": { buildkit: true} to "features": { buildkit: false}.