[infinispan-issues] [JBoss JIRA] (ISPN-9915) JDBC publish Flowable should explicitly rollback connection

[Tristan Tarrant (Jira)]

     [ https://issues.jboss.org/browse/ISPN-9915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tristan Tarrant updated ISPN-9915:
----------------------------------
    Sprint: Sprint 10.0.0.Beta1, JDG Sprint #31  (was: Sprint 10.0.0.Beta1)


> JDBC publish Flowable should explicitly rollback connection
> -----------------------------------------------------------
>
>                 Key: ISPN-9915
>                 URL: https://issues.jboss.org/browse/ISPN-9915
>             Project: Infinispan
>          Issue Type: Bug
>          Components: Loaders and Stores
>    Affects Versions: 10.0.0.Alpha3, 9.4.6.Final
>            Reporter: Ryan Emerson
>            Assignee: Ryan Emerson
>            Priority: Major
>             Fix For: 9.4.7.Final, 10.0.0.Beta1
>
>
> The Flowable for the JDBC store publisher sets `autoCommit(false)` in order for pagination to work as expected, however we never explicitly call commit or rollback on the connection, therefore the exact behaviour is determined by the underlying connection pool. Instead we should explicitly call rollback() on the connection after the publisher has finished, because the operation is read only. 



--
This message was sent by Atlassian Jira
(v7.12.1#712002)