Camunda-spring-boot-starter ignores spring-datasource.url pointing to h2 file based

Camunda 7 Topics Discussion & Questions
1

Hi,

I’ve a spring-boot app with camunda-spring-boot-starter:3.0.0 and configured a h2 file based database in my application.yaml:

spring.datasource:
  url: jdbc:h2:./camunda-db;DB_CLOSE_DELAY=-1;MVCC=TRUE;DB_CLOSE_ON_EXIT=FALSE
  username: sa
  password: sa

But the log says, that the server uses an in memory database:

2018-06-28 22:51:39.428  INFO 20900 --- [           main] o.s.j.d.e.EmbeddedDatabaseFactory        : Starting embedded database: url='jdbc:h2:mem:testdb;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false', username='sa'

Does anybody have an idea why?

Using spring-boot:2.0.2.RELEASE.

A testproject can be generated from the camunda-archetype-spring-boot:7.9.0

Thanks in advance, Ingo

2

Hi Ingo,

You need to add one additional dependency “spring-boot-starter-jdbc” otherwise the spring.datasource configuration is ignored. (Note this is not related to camunda spring boot but to spring boot itself.)

For more information please check the following paragraph:
https://docs.spring.io/spring-boot/docs/current/reference/html/boot-features-sql.html#boot-features-connect-to-production-database

Best regards,
Yana

6 Likes
3

That’s it!

Thank you @yana.vasileva.

4