We are trying to do a basic query using the HXTT 3.0 access driver (Core + Common) through coldfusion, which is running on top of tomcat. We are getting a Java heap space error, despite that fact that our heap size was set initially to 512, and then to 1024. There are only a few thousand records in this test database, with only two columns.
"Error","http-169.237.69.125-8080-Processor25","07/14/08","15:23:55",,"Java heap space The specific sequence of files included or processed is: /webdev/test/www/cfusion/crcentral/content/rating/test3.cfm "
java.lang.OutOfMemoryError: Java heap space
our code is only doing the following:
SELECT *
FROM inv_sum_dataset.inv_dtl_usage_outbound
#count# -- #inv_dtl_id#
Any help would be appreciated.
|
The issue seems to be that the HXTT Access driver is looping through the access file, and displaying records more than once. It will continue doing this until a) we set a maxrows in the coldfusion code, or b) coldfusion runs out of memory.
Nate
|
If possible, please zip and emal us that mdb sample. It seems that some wrong page numbe resulted that record loop.
|
v3.0.046 fixed a bug since v3.0.040. Please download it. Then your issue should disappear. Thanks.
|