db2 type 4 driver result set fetch size

santosh.veerlapat · #1 (**permalink**) 08-11-11, 03:04

I m using jdbc code to retrieve records in db2 and using type 4 driver db2jcc.jar.
Does it supports setting for fetch size on statement or prepared statement or not?

Because i have 1 million records in my database,if the result set loads all at one shot then my java program will through out of memory exception.

thanks in advance
santosh kumar veerlapati

przytula_guy · #2 (**permalink**) 08-11-11, 03:21

when declaring a cursor and fetching from this cursor there is a blocking mechanism
I believe you get blocks of data, whenever you fetch new data
the block is limited in size (8k I believe)
should be verified..
there are some topics in doc regarding this.. see
http://publib.boulder.ibm.com/infoce.../t0005281.html

dr_te_z · #3 (**permalink**) 08-11-11, 06:29

Not sure, I think you can control that with the setting of "enableRowsetSupport" described here: DB2 Database for Linux, UNIX, and Windows

Internet Services

Web Development

Digital Marketing

Consumer Tech