Hi all
I have writeen program which read text file and insert each records into SQL 2000. Text file has around 200,000 records. The problem i have found is it consumes lots of memory while program is running and inserting records. The memory goes up to 256MB and start decreasing and than at some stage it throws OutOfMomory Error message.
Most of my variables are Stirng and few float. Its a very simple
java application, which load
jdbc driver, make conncetion to data base and prepare sql statement and so on.
I thought garbage collector should run automatically when jvm reaches max to the heap size but i think gc is not able to free enough momory for the request and therefore i got outofmomory error message.
Hope some has same kind of problem and have some kind of solutions.