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

[William Burns (Jira)]

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

William Burns updated ISPN-9752:
--------------------------------
              Status: Pull Request Sent  (was: Open)
    Git Pull Request: https://github.com/infinispan/infinispan/pull/6445, https://github.com/infinispan/infinispan/pull/6446


> 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
>            Priority: Major
>
> Some JDBC drivers do not do paging for result sets when auto commit is disabled, 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)