Hi guys...please help me solve this error..I tried everything i could but all in vain...
In the code I wrote, first i set up a JDBC connection. Then I read contents of an excel sheet (using JExcel API). Then I call an oracle procedure (using CallableStatement) which has return parameters. This call to procedure is once for each row in the excel. Then I write the out parameters in another excel.
But the program is not able to process more than 150 rows.
here is what i get:
Exception in thread "main" java.lang.OutOfMemoryError: Java heap space
I even increased the heap space. Please help me out. Thanks in advance.
How big is your input file? Can we call your procedure in one go rather than one by one? If you input file is too big, try reading the necessary contents and closing it. Post code if you are allowed to.
If I become filthy rich, I'll sponsor research for painless dental treatment at Harvard Medical School. Thats why,I'm learning Java.I have 32 teeth, 22 are man made.
posted 9 years ago
Hello guys...thanks for your reply...
I found the mistake....i had put the callable statement's declaration in a loop....just becaust the code was too big, i couldnt find it...