Re: [RFC] How about changing the default value of defaultRowFetchSize?
| От | Jorge Solórzano |
|---|---|
| Тема | Re: [RFC] How about changing the default value of defaultRowFetchSize? |
| Дата | |
| Msg-id | CA+cVU8PEUrc7eZcQkrpBTSD6+zTgdr7WP=McnOWx6wBF638sOA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [RFC] How about changing the default value of defaultRowFetchSize? (Mark Rotteveel <mark@lawinegevaar.nl>) |
| Ответы |
Re: [RFC] How about changing the default value of defaultRowFetchSize?
Re: [RFC] How about changing the default value ofdefaultRowFetchSize? |
| Список | pgsql-jdbc |
On Thu, Oct 20, 2016 at 6:53 AM, Mark Rotteveel <mark@lawinegevaar.nl> wrote:
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.
In other words, PostgreSQL JDBC couldleave 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"
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 по дате отправления: