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
