Re: jdbc outofmemoryerror

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hello Eric,

The first thing I would do is go over your program and make sure you are 
freeing up all of necessary JVM object references with freeLocalRef or 
begin/end object groups.  Anything you do not free up with these will be 
left "in use" inside the Java Virtual Machine (JVM) and if enough of 
these build up, you'll run out of memory.

If that doesn't help, and you're still running out, you could increase 
the amount of memory available to the JVM.  There's a good discussion on 
how to do that, here: 
https://www.geeksforgeeks.org/how-to-increase-heap-size-in-java-virtual-machine/

Since you are running it from an RPG program, you'll need to set these 
settings in the QIBM_RPG_JAVA_PROPERTIES environment variable as 
explained here: 
https://www.ibm.com/docs/en/i/7.4?topic=rj-controlling-how-java-virtual-machine-is-set-up

Good luck!


On 8/10/22 1:16 PM, eric bothes wrote:
> im using Scotts JDBC to write records to a MS SQL database.
>
> After so many records are written, i get java exception 
> java/lang/OutOfMemoryError and the programs dumps out.
>
> The code uses jdbc_prepStmd/jdbc_execprepupd  to insert records into 
> the table.