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