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

From Jorge Solórzano
Subject Re: [RFC] How about changing the default value of defaultRowFetchSize?
Date
Msg-id CA+cVU8PEUrc7eZcQkrpBTSD6+zTgdr7WP=McnOWx6wBF638sOA@mail.gmail.com
Whole thread Raw
In response to Re: [RFC] How about changing the default value of defaultRowFetchSize?  (Mark Rotteveel <mark@lawinegevaar.nl>)
Responses Re: [RFC] How about changing the default value of defaultRowFetchSize?  (Vladimir Sitnikov <sitnikov.vladimir@gmail.com>)
Re: [RFC] How about changing the default value ofdefaultRowFetchSize?  (Mark Rotteveel <mark@lawinegevaar.nl>)
List pgsql-jdbc
On Thu, Oct 20, 2016 at 6:53 AM, Mark Rotteveel <mark@lawinegevaar.nl> wrote:

In other words, PostgreSQL JDBC could
​​
leave the default at 0, but then use a default fetch size.

 

That's seems wrong, the Fetch Size should be correctly reported, the defaultRowFetchSize property can be changed to 100 but a call to getFetchSize() should return 100 not 0.

Based on the driver docs:
"defaultRowFetchSize: Default parameter for java.sql.Statement#getFetchSize(). A value of 0 means that need fetch all rows at once"

The value of 0 should be used to fetch all rows, if we ​leave the default at 0 and handle internally that as 100 (and reporting it as 0) it is a wrong behavior.

​Regards,​

pgsql-jdbc by date:

Previous
From: Jorge Solórzano
Date:
Subject: Re: [RFC] How about changing the default value of defaultRowFetchSize?
Next
From: Vladimir Sitnikov
Date:
Subject: Re: [RFC] How about changing the default value of defaultRowFetchSize?