[infinispan-issues] [JBoss JIRA] (ISPN-9916) JDBC Publish Flowable should explicitly close all ResultSets

[Ryan Emerson (Jira)]

Ryan Emerson created ISPN-9916:
----------------------------------

             Summary: JDBC Publish Flowable should explicitly close all ResultSets
                 Key: ISPN-9916
                 URL: https://issues.jboss.org/browse/ISPN-9916
             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
             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)