DB Connections

Camunda 7 Topics Discussion & Questions
1

Hi, we’re using Camunda together with Spring Boot and PostgreSQL. I wonder if someone can tell me, how many DB connections the Camunda process engine opens during runtime and if this can be configured? I’m asking this, because we’re struggeling with our platform provider who restricts the DB connections.
Thanks and best regards, Roland

2

Hi @Roland,

there isn’t much Camunda logic involved. Have a look at the data source configuration: https://github.com/camunda/camunda-bpm-spring-boot-starter/blob/master/starter/src/main/java/org/camunda/bpm/spring/boot/starter/configuration/impl/DefaultDatasourceConfiguration.java

The rest is done in spring-boot (-magic).

Hope this helps,

Ingo

3

Hi

I am strugling to set up spring boot, camunda with postgresql. When i run mvn clean install, i get that tables in camunda is not present, even though i can see they are created.

Here is my setup:

Would be grateful for inputs.

4

Hi @FrankReneSorensen,

you configured a prefix for the schema, so you should create the tables manually. See the Heads up at the end of this section: https://docs.camunda.org/manual/7.10/installation/full/tomcat/manual/#create-the-database-schema-and-tables

Or remove the prefix from the configuration.

Hope this helps, Ingo

1 Like
5

Hi

But, will i have to create the tables manually if i remove the prefix properties?

Best regards

Frank

6

Hi @FrankReneSorensen,

if the database user is allowed to create tables and you have set the property to create the table, the engine will do this you.

If you need a specific prefix for your database table, then the engine can’t create the tables.

Hope this helps, Ingo

1 Like
7

Hi @Ingo_Richtsmeier

Now I got it to work. Thanks for your help!

I am testing out a BPMN process in Camunda that should be triggered by a message from kafka. I want to try out Spring Kafka. Do you have any good articles og examples of that?

Anyway…you have helped me a lot! :slight_smile:

8

Hi @FrankReneSorensen,

Bernd has done something for this: https://github.com/berndruecker/flowing-retail/tree/master/kafka/java/order-camunda.

Have a look at the readme: https://github.com/berndruecker/flowing-retail to get an overview about the bits and pieces.

Hope this helps, Ingo

1 Like
9