[infinispan-issues] [JBoss JIRA] (ISPN-9752) JDBCStringBasedStore should disable auto commit for publish methods

[Ryan Emerson (Jira)]

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

Ryan Emerson resolved ISPN-9752.
--------------------------------
    Fix Version/s: 10.0.0.Alpha2
                   9.4.3.Final
         Assignee: William Burns
       Resolution: Done


> JDBCStringBasedStore should disable auto commit for publish methods
> -------------------------------------------------------------------
>
>                 Key: ISPN-9752
>                 URL: https://issues.jboss.org/browse/ISPN-9752
>             Project: Infinispan
>          Issue Type: Bug
>            Reporter: Nicolas Ocquidant
>            Assignee: William Burns
>            Priority: Major
>             Fix For: 10.0.0.Alpha2, 9.4.3.Final
>
>
> Some JDBC drivers do not do paging for result sets when auto commit is enabled, namely postgresql
> https://jdbc.postgresql.org/documentation/83/query.html#query-with-cursor
> There shouldn't be any drawbacks of disabling auto commit before performing the query. We wouldn't even need to rollback/commit the connection and just return it to the pool. The pool can do that for us as we don't care if it is committed as it is a read only query.
> Could you please give the opportunity to disable autoCommit in order for the JDBC page size to work (even if the store is not transactional).
> Otherwise, fetch size is ignore and postgresql just pulls in the entire select.
> Thanks
> --nick



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