Flowable complains that autocommit is enabled when I go to http://localhost:8080/flowable-rest/service/runtime/tasks/xxxxxxxx/variables.
org.springframework.transaction.TransactionSystemException: Could not commit JDBC transaction; nested exception is org.postgresql.util.PSQLException: Cannot commit when autoCommit is enabled.
- CentOS 7.6
- Flowable v6.4.0
- Tomcat v8.5.42
- PostgreSQL 10.7
- pgSQL connector v42.2.6
db configuration
spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://x.x.x.x:5432/flowable?autocommit=false
spring.datasource.username=flowable
spring.datasource.password=***hidden***
note: the db property ?autocommit=false
doesn’t work, btw there is no option like this (https://github.com/pgjdbc/pgjdbc#connection-properties) so auto-commit cannot be disabled in the connection URL