[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:
--------------------------------
    Description: 
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

  was:
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



> 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 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)