Re: setFetchSize()

Rich Cullingford wrote:

> All,
> Will this function be implemented in Release 7.4? I have several arge
> tables that run Java out of memory when I attempt to load them through
> JDBC. Any workarounds arppreciated...

I was using cursors for a while as a workaround...
Something like this:

c.setAutocommit (false);
Statement s = c.createStatement ();
s.execute ("declare foo cursor for select * from bar");

while (true)
{
ResultSet rs = s.executeQuery ("fetch 10 from foo");
int count = 0;
while (rs.next ())
{
count++;
doStuffWithThisRow (rs);
}

if (count < 10) //The whole cursor contents has been processed
break;
}


I hope, it helps...

Dima