On 26-09-2006 10:18:15 -0700, George H wrote:
With the table, "test" having 4 million rows using sql and jdbcclient:
geo->select column1 from test;
It displays the column1 query results for about 10 seconds and then the jdbcclient-1.4.jar crashes leaving the following message before it bugs out:
Exception in thread "main" java.lang.OutOfMemeoryError
Does it give a clue in the stack trace? I think I already know what blows it up.
I tried many many combinations of java options concerning memory and gc to try to fix it but in my hands, no luck.
I'll try and see if I can patch it up, with 4 milion rows my anticipatory block size incrementing reaches a point of no more memory :)
I worked around this by switching to the MapiClient which works just fine.
Does it show you the 4 milion rows, or just a subset of it?