From: davecramer@gmail.com [mailto:davecramer@gmail.com] On Behalf Of > Dave Cramer > 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.
I got your point, thanks. I agree that getFetchSize() returns 0 when setFetchSize() hasn't been called yet or setFetchSize(0) was called. Users can interpret the return value of 0 as (1) defaultRowFetchSize if autocommit is off, or (2) all rows if autocommit is on.
I think I'll submit a patch. Of course, I don't mind if anyone will do it.