Document MySQL connector's fetchSize behaviour in ResultQuery.fetchSize()

[gabadi]

I've a query with 3M rows, so i execute it with a cursor. But it seams like jooq it's keeping all the result in memory because i've GC limit exception during the fecth.

i've tried:
query.fetchLazy(fetchSize)
query.fetchSize(fetchSize).fetchLazy()

but without any success.

Any idea of what may be happening

[gabadi]

I love mysql
this solves the mysql jdbc issue:
query.fetchSize(Integer.MIN_VALUE).fetchLazy()

[lukaseder]

Yes, I've stumbled upon this too, in the past... Perhaps, we could add a remark to the Javadoc?

[lukaseder]

Interesting caveat with setting Integer.MIN_VALUE:

• http://stackoverflow.com/a/2448607/521799
• http://bugs.mysql.com/bug.php?id=42929