Skip to content

Allow to specify autocommit flag to be explicitly set on AbstractCursorItemReader's connection [BATCH-2661] #943

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
spring-projects-issues opened this issue Nov 30, 2017 · 0 comments
Closed

Allow to specify autocommit flag to be explicitly set on AbstractCursorItemReader's connection [BATCH-2661] #943

spring-projects-issues opened this issue Nov 30, 2017 · 0 comments
Labels
in: infrastructure type: enhancement
Milestone
4.0.0

Comments

@spring-projects-issues
Copy link
Collaborator

Michael Minella opened BATCH-2661 and commented

The use case was to use a JdbcCursorItemReader with PostgreSQL (nothing fancy here).
From https://jdbc.postgresql.org/documentation/94/query.html, section "Getting results based on a cursor", the connection must not be in auto commit mode.
But JdbcCursorItemReader does not allow to explicity set connection mode to autoCommit = false.

As discussed in the Spring Boot PR, configuring the JDBC pool to force all connection to autoCommit=false is not an optimal way to workaround the problem.

Affects: 4.0.0.RC1

Reference URL: spring-projects/spring-boot#7866

Referenced from: pull request #446
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
in: infrastructure type: enhancement
Projects
None yet
Milestone
4.0.0
Development

No branches or pull requests
1 participant
@spring-projects-issues