I am trying to limit the fetch size of my select query.
Unfortunately the JTDS MS SQL driver still reads all rows.
I do not want a limit or offset select.
I just want to save my memory such that I need less RAM.
I do not need setMaxRows.
My sample code:
mySql="select * from myVeryLargeTable";
rs = s.executeQuery(mySql);
rs.next(); // here all rows are coming in over network but i only want 'batchSize'
How can I limit the fetch size?