PostgreSQL Integration

[hello.aliasad]

Hi all, do we have a guideline available to integrate PostgreSQL into camunda application. I’m using the project template from start.camunda.com. I don’t want to use the default H2 database in my application. Would appreciate a blog/guideline/best Practice/ video.

Thanks in Advance,
Ali

[aravindhrs]

@hello.aliasad,

Add this dependency to the classpath:

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
    <version>2.2.1.RELEASE</version>
</dependency>

And refer this post for datasources configuration:

Camunda Spring Boot Starter & Postgres

Should have taken things a little slower here and verified the pom. So, I was missing spring-boot-starter-jdbc and I included the following as per the docs: camunda.bpm.database.type=postgres spring.datasource.url=jdbc:postgresql://localhost:5432/camunda spring.datasource.username=??? spring.datasource.password=??? spring.datasource.driver-class-name=org.postgresql.Driver #camunda.bpm.database.schema-update=create-drop camunda.bpm.database.table-prefix=camunda. Seems to be working well. …

Unable to build Camunda DB with Spring Boot and Postgresql

@ aravindhrs Below are the dependencies added <dependency> <groupId>org.camunda.bpm.springboot</groupId> <artifactId>camunda-bpm-spring-boot-starter</artifactId> <version>3.1.1</version> </dependency> <dependency> <groupId>org.camunda.bpm.springboot</groupId> <artifactId>camunda-bpm-spring-boot-starter-rest</artifactId> <version>3.1.1</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc<…

[hello.aliasad]

@aravindhrs thanks for the solution. Just one quick question, where do we get url value from? Will given url value works fine?
spring.datasource.url=jdbc:postgresql://localhost:5432/camunda

[aravindhrs]

@hello.aliasad if you install the postgres database in your local machine with same port, then the url work fine. And schema you need to create it, empty schema is enough, engine will auto create the tables for you. You need to enable autoschema update as true.

[hello.aliasad]

Thank you so much, really apprciate it. With postgreSQL integration do we need to include the H2 database dependency in the pom.xml file or we can remove that dependency?

[aravindhrs]

@hello.aliasad h2 is not required. you can remove it

[hello.aliasad]

appreciate it. Thanks