Re: [RFC] How about changing the default value of defaultRowFetchSize? - Mailing list pgsql-jdbc

On 20-10-2016 19:30, Jorge Solórzano wrote:
> ​So if the driver internally handle fetch size 0 == fetch size 100,
> that's what i call an hidden inconsistent behavior.
>
> Don't get me wrong, it make sense to switch ​defaultRowFetchSize to
> "100", but a call to getFetchSize() should be == 100, not 0.

And that is how it should work, however according to the JDBC
specification (or at least: that is how I read it),
Statement.setFetchSize(0) means "use driver default fetch size".

On the other hand, drivers are also free to ignore fetch size hints.

Mark
--
Mark Rotteveel