One Table has 4,5 million rows.
I am Exporting those rows to another table and I am getting this error message.
"Exception in thread "main" java.lang.OutOfMemoryError: Java heap space"
I read many discussions about that same problem and I applied these configurations:
+ For the cursor in the input component: 100000
+ For the advanced settings of the execution tab for the JVM parameters: -Xms1024 // -Xmx1024 // -XX:-UseGCOverheadLimit
Please find attached the design of my job.
I want to know if it's an optimization issue ( so I have to change the design of the job, ...which it's not very possible due to business model matters) or it's a classic memory issue (so I have just to increase the memory for JVM).
I'm on Talend Open Studio for Data Integration 6.5.1.
I have to wait 2 hours for each test... it's a little bit hard lol
Thanks for your time and answers!
Hello TRF! Thank you for your answer and attention!
Yes I did it once... -Xms2048, but with a -Xmx245 (not sure about the value and the role of this parameter)