Re: Java Exception in JDBCR4

Respectfully, I have the same problem with a Java-only implementation of
POI/HSSF on my PC. When I work with very large spreadsheets, I run out
of memory. One might argue that I haven't set my JVM up properly, and
one would be correct. But this is not something I worried about in RPG
since I left the overlay linkage editor behind on System/3.

POI/HSSF is not well suited for larger spreadsheets, it takes the complete sheet to memory - and if it's big enough, you will run into memory problems; but this is mainly a problem of the Excel format (Horrible SpreadSheet Format). Writing this in RPG would take years and you would run into memory problems quite more easy. Java is one of the easiest languages to deal with dynamic memory allocation, to allocate memory, you would simply use the new operator and if nobody needs the variable any more, the memory is freed by the garbage collector. To enforce this, simply set the variable to null and if no refernece is pointing to the storage anymore, it's deallocated automatically. dynamic memory allocation using RPG is by far more difficult, you would have to allocate and deallocate the memory by your own, with could be dangerous, if you've passed the pointer to another module. BTW: without using RCLRSC or RCLACTGRP, you will fill up memory with no more used variables...

Dieter