[infinispan-issues] [JBoss JIRA] (ISPN-10337) JDBC Purge consistency issues

[Ryan Emerson (Jira)]

Ryan Emerson created ISPN-10337:
-----------------------------------

             Summary: JDBC Purge consistency issues
                 Key: ISPN-10337
                 URL: https://issues.jboss.org/browse/ISPN-10337
             Project: Infinispan
          Issue Type: Bug
          Components: Loaders and Stores
    Affects Versions: 10.0.0.Beta3
            Reporter: Ryan Emerson
            Assignee: Ryan Emerson


The JdbcStringBasedStore's purge method requires the following enhancements:

# The connection should be enrolled in a transaction via {{autoCommit(false)}}  with commit/rollback.
# Implementations of {{TableManager#getSelectOnlyExpiredRowsSql}} should utilise a SELECT ... FOR UPDATE statement to ensure that the expired entries are locked throughout the Tx



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