Use Postgresql database in development docker-compose

[MLenterman]

• Add postgresql service to docker-compose
• Create context.xml for postgresql with ${variables} that can be given to JVM with -Dparam ()
• Mount context.xml in zaakbrug container

[philipsens]

I've used this one for FaaS in the past:

<?xml version="1.0" encoding="UTF-8"?>
<Context>
    <JarScanner scanClassPath="false" scanAllFiles="false" scanAllDirectories="false"/>

    <Resource name="jdbc/${database.instance.name}" auth="Container"
              type="javax.sql.DataSource"
              driverClassName="org.postgresql.Driver"
              url="jdbc:postgresql://${database.host}:${database.port:-5432}/${database.name}"
              username="${database/username:-postgres}"
              password="${database/password}"
              maxTotal="50"
              maxWaitMillis="5000"
    />
</Context>

But it might be outdated. This is the one I use in the Helm Chart, note that this is the XA variant and you should enable a transaction manager in Tomcat.

<Resource 
              name="{{ .name | default (printf "jdbc/%s" $.Values.frank.instance.name) | lower }}" 
              factory="org.apache.naming.factory.BeanFactory"
              type="org.postgresql.xa.PGXADataSource" 
              URL="jdbc:postgresql://{{ .host }}:{{ .port | default 5432}}/{{ .database | default $.Values.frank.instance.name }}"
              user="{{ .username }}"
              password="{{ .password }}"
              sslMode="{{ ternary "REQUIRE" "DISABLE" (.ssl | default false)}}"
            />

To enable the transaction manager, add this property: application.server.type.custom: NARAYANA