Database-configuration to connect SQL-Server with Camunda BPM

Camunda 7 Topics Discussion & Questions
1

Hello Community,

I am a absolutly beginner in Camunda BPM and I try to find out how we establish a process for a study-education-project.

For that project, we installed SQL-Server 2016 and Camunda BPM 7.7.

Now we try to connect SQL-Server with Camunda BPM. We read this section of the Manual " https://docs.camunda.org/manual/latest/user-guide/process-engine/database/#database-configuration " but do not find where we can change the entries to establish a connection via JDBC.

Is it a configuration-file or a setting in Camunda BPM? Where can I change this entries?

Best wishes
TG

2

Hi @TheGrump,
which application server are you using?

In case of Tomcat you should adjust conf/server.xml file. This part:

<Resource name="jdbc/ProcessEngine"
          auth="Container"
          type="javax.sql.DataSource" 
          factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
          uniqueResourceName="process-engine"
          driverClassName="org.h2.Driver" 
          url="jdbc:h2:./camunda-h2-dbs/process-engine;MVCC=TRUE;TRACE_LEVEL_FILE=0;DB_CLOSE_ON_EXIT=FALSE"
          defaultTransactionIsolation="READ_COMMITTED"
          username="sa"  
          password="sa"
          maxActive="20"
          minIdle="5" />
3

Hi @sdorokhova

Yes, We using Tomcat and thank you for your helpfull comment. :slight_smile:
I see that the entries are for h2-database but to change that will be not a problem…i hope so. :wink:

4

You will also need to put database driver JAR in Tomcat lib directory.

5

Yes, that is correct if that is the way to exchange datas between Camunda BPM-Engine and SQL-Server database. Isn´t it?

6