Re: [RFC] How about changing the default value of defaultRowFetchSize?

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: [RFC] How about changing the default value of defaultRowFetchSize?
Дата
Msg-id CADK3HHJJ0TVmu_2k0C+piyGOvtC8qJjK8ywJtU_MSE6T-xnvjw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [RFC] How about changing the default value of defaultRowFetchSize?  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
Ответы Re: [RFC] How about changing the default value ofdefaultRowFetchSize?
Список pgsql-jdbc

On 24 October 2016 at 23:15, Tsunakawa, Takayuki <tsunakawa.takay@jp.fujitsu.com> wrote:
From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of
> Dave Cramer
> This is what I take issue with. It should return 0 which means that it has
> not been set. What use is it to the user ?

I'm sorry to repeat myself.  According to the API doc, the use of getFetchSize() is to retrieve the number of result set rows, not the hint value.  So, I thought 0 was not appropriate because 0 is only a valid hint value passed to setFetchSize().   Which sentence in what document does your returning 0 follow?

http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html

Retrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object.
 
If this Statement object has not set a fetch size by calling the method setFetchSize, the return value is implementation-specific.

This states that if setFetchSize has not been called then we return what we want. Given that if the statement is in auto-commit then the fetch size is irrelevant. The correct logic would be if autocommit=false then return the default value, otherwise 0, but I'm not advocating this either.

So my question to you is how would you use this information anyway? It's not like you can allocate more memory or something to accommodate the rows. It makes more sense to me that if I get 0 back then I know I have to set it. If I get the value back that I set it to then I know what's going on. I would assert that anyone that is knowledgable enough to use this is going to call setFetchSize.



В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: [RFC] How about changing the default value of defaultRowFetchSize?
Следующее
От: Ziyun Audrey Wang
Дата:
Сообщение: postgresql support new time zone TRT