How to disable autocommit Spring Boot?

Question

I'm trying to disable autocommit, but I'm not lucky. I'm using the Spring Boot version 2.1.3.RELEASE

application.properties

spring.jpa.database=oracle
spring.jpa.database-platform=org.hibernate.dialect.Oracle12cDialect
spring.jpa.generate-ddl=false
spring.jpa.open-in-view=true
spring.jpa.show-sql=false
spring.datasource.hikari.auto-commit=false

the question already exist check [here](https://stackoverflow.com/questions/51989745/spring-boot-2-disable-autocommit-hikari-with-multiple-datasources) — Djamel Kr, Mar 25 '19 at 17:52
yes, but not did not work. I tried too ```spring.datasource.ucm.autocommit=false``` ```spring.datasource.ucm.default-auto-commit=false``` @Dylan — Andre Soares, Mar 25 '19 at 18:48
how did you solve the problem, could you share the correct one please? — Katha patel, Mar 15 '22 at 08:50

score 9 · Answer 1 · answered Mar 25 '19 at 21:26

9

Use

spring.datasource.auto-commit=false

This property (and some more too) were not documented.

Please refer below github issue for more undocumented properties.

https://github.com/spring-projects/spring-boot/issues/1829

answered Mar 25 '19 at 21:26

Sundararaj Govindasamy

8,180
5
44
77

score -1 · Answer 2 · answered Jul 25 '23 at 14:45

-1

With Spring Boot 3, the connection pool has been changed to HikariCP and the parameter is now : spring.datasource.hikari.auto-commit=false

answered Jul 25 '23 at 14:45

Eric Colinet

1

How to disable autocommit Spring Boot?

2 Answers2

Linked