[infinispan-issues] [JBoss JIRA] (ISPN-201) make JDBC cache store use DB transactions for commit/rollback

[Tristan Tarrant (JIRA)]

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

Tristan Tarrant reassigned ISPN-201:
------------------------------------

    Assignee: Tristan Tarrant  (was: Mircea Markus)

    
> make JDBC cache store use DB transactions for commit/rollback
> -------------------------------------------------------------
>
>                 Key: ISPN-201
>                 URL: https://issues.jboss.org/browse/ISPN-201
>             Project: Infinispan
>          Issue Type: Feature Request
>          Components: Loaders and Stores
>            Reporter: Mircea Markus
>            Assignee: Tristan Tarrant
>             Fix For: 5.2.0.FINAL
>
>
> current impl of JDBC cache store does not use DB transaction (nor local transactions/Connection.setAutocommit(false)) for storing the modifications created within a transaction. This might leave the store in an inconsistent state one operation fails during commit. This should be changed to either 1. use local transactions or 2. register the driver as an XAResource and rely on the TM to manage the boundaries. I would go for 1, as it would be more consistent with other CStore implementation (different cache store interceptor should be used for managing the 2'nd approach).  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira