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

[Ryan Emerson (Jira)]

Ryan Emerson created ISPN-9915:
----------------------------------

             Summary: 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: 9.4.6.Final, 10.0.0.Alpha3
            Reporter: Ryan Emerson
            Assignee: Ryan Emerson
             Fix For: 10.0.0.Beta1, 9.4.7.Final


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)