This projects contains different Docker containers for deegree webservices. Please consult the deegree documentation for further information how to configure and use deegree web services. The Docker web site provides all information about Docker!
Get docker image for PostgreSQL DB and start the container:
% docker pull postgis/postgis:14-3.4
% docker run -p 5432:5432 --name db -e POSTGRES_PASSWORD=secretpassword -d postgis/postgis:14-3.4
see https://hub.docker.com/r/postgis/postgis/ for more information.
Then start the container with deegree webservices:
% docker run --name deegree --link postgis:db -p 8080:8080 -d tfr42/deegree:latest
To configure a JDBC connection connect to the deegree console and enter the JDBC URL:
<?xml version='1.0' encoding='UTF-8'?>
<JDBCConnection xmlns='http://www.deegree.org/jdbc' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xsi:schemaLocation='http://www.deegree.org/jdbc https://schemas.deegree.org/core/3.5/jdbc/jdbc.xsd'>
<Url>jdbc:postgresql://db:5432/postgres</Url>
<User>postgres</User>
<Password>postgres</Password>
<ReadOnly>false</ReadOnly>
</JDBCConnection>
To configure a JDBC connection connect to a Oracle Database use:
<?xml version='1.0' encoding='UTF-8'?>
<JDBCConnection xmlns="http://www.deegree.org/jdbc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.deegree.org/jdbc https://schemas.deegree.org/core/3.5/jdbc/jdbc.xsd">
<Url>jdbc:oracle:thin:@db:49161:xe</Url>
<User>system</User>
<Password>oracle</Password>
<ReadOnly>false</ReadOnly>
</JDBCConnection>
First download the Oracle JDBC driver from Oracle Tech Net Then copy the JAR file into the $CATALINA_HOME/lib directory inside the docker container:
% docker cp PATH_TO/ojdbc8.jar deegree:/usr/local/tomcat/lib
Before configuring a JDBC connection to the Oracle DB you need to restart the docker container:
% docker restart deegree
Here an example how to fix issue with Oracle JDBC when running in 'ORA-01882: timezone region not found':
% docker run --env CATALINA_OPTS="-Doracle.jdbc.timezoneAsRegion=false -Duser.timezone=CET" -d tfr42/deegree:latest