How to use MSSQL with docker image


#1

The scenario I am trying to achieve is to have camunda running on a docker container, but the database should be Azure MS SQL, Not mysql, not postgress as MSSQL is our preferred DB.

I already tested it with h2 and mysql and it works fine

However I am not able to install the JDBC Drivers correctly.

I used your docker file, but I changed a few things

#MSSQL SERVER JDBC DRIVER INSTALL
COPY sqljdbc_7.2.2.0_enu.tar.gz /tmp/
WORKDIR /tmp
RUN tar -xf sqljdbc_7.2.2.0_enu.tar.gz
ENV CLASSPATH ${CLASSPATH}:/tmp/sqljdbc_7.2/enu/mssql-jdbc-7.2.2.jre11.jar
ARG CLASSPATH=${CLASSPATH}:/tmp/sqljdbc_7.2/enu/mssql-jdbc-7.2.2.jre11.jar
RUN echo $CLASSPATH

ENV CAMUNDA_VERSION=${VERSION}
ENV DB_DRIVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
ENV DB_URL=jdbc:sqlserver://xx.database.windows.net:1433;database=xx;user=demo@architectureplaygroundcamunda;password=xx.;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
ENV DB_USERNAME=xx@architectureplaygroundcamunda
ENV DB_PASSWORD=x

However I have this error:

Can you help me a bit with this?