I
Ian Suttle
Hey all. I am having an issue with the java.lang.outofmemoryerror. I
am loading a resultset from SQL 2000 into my console application in
Windows XP. The recordset consists of 1,000,000 rows (all rows in
table) which I convert to an array structure. This was working fine
until I added additional data to the array from the resultset. In
total, the physical table size is 35,840KB. When I monitor the amount
of memory being used via Task Manager, it throws the error at about 75
MB consistently.
I have tried to break up the query into parts of 250,000 thinking that
all of the data from the 1,000,000 rows is too much memory overhead in
addition to storing the data in the arrays. This has the same effect
once I get to about 75MB of Mem Usage.
I have also watched the heap size within JBuilder9, which has an
allocated heap size of 31.8MB. When the error occurs, the utilized
portion of the heap is also around the allocated size. I have tried
running this application within JBuilder and as a compiled EXE.
If anyone has any suggestions as to how to get around whatever
limitations are occurring here, please let me know.
The following are the specs of the test:
Microsoft Windows XP - SP1
P4 - 1.8GHZ
640MB RAM
JDK 1.4.1
JBuilder 9 Enterprise
Thanks in advance!
Ian Suttle
Zing.com
am loading a resultset from SQL 2000 into my console application in
Windows XP. The recordset consists of 1,000,000 rows (all rows in
table) which I convert to an array structure. This was working fine
until I added additional data to the array from the resultset. In
total, the physical table size is 35,840KB. When I monitor the amount
of memory being used via Task Manager, it throws the error at about 75
MB consistently.
I have tried to break up the query into parts of 250,000 thinking that
all of the data from the 1,000,000 rows is too much memory overhead in
addition to storing the data in the arrays. This has the same effect
once I get to about 75MB of Mem Usage.
I have also watched the heap size within JBuilder9, which has an
allocated heap size of 31.8MB. When the error occurs, the utilized
portion of the heap is also around the allocated size. I have tried
running this application within JBuilder and as a compiled EXE.
If anyone has any suggestions as to how to get around whatever
limitations are occurring here, please let me know.
The following are the specs of the test:
Microsoft Windows XP - SP1
P4 - 1.8GHZ
640MB RAM
JDK 1.4.1
JBuilder 9 Enterprise
Thanks in advance!
Ian Suttle
Zing.com