java.lang.OutOfMemoryError: Java heap space
at java.io.BufferedWriter.<init>(Unknown Source)
at java.io.BufferedWriter.<init>(Unknown Source)
at java.io.PrintWriter.<init>(Unknown Source)
at com.mathworks.jmi.OpaqueJavaInterface.getExceptionMessage(OpaqueJavaInterface.java:1313)
??? Failed to retrieve Exception Message
Does anyone know how to improve the fast insert. Some parameter that can help in sending it in series and not waiting to send the data. My autocommit is on, so I expected to dont store the process in the memory.
On the other hand, if no solution is possible, how can I calculate the maximum number of records I can try to insert at once. And if the exact number is not possible, how can I make it do the process in serial and not wait till he tries to keep al in memory (without needing to iterate my code one by one).
Any info is appreciated.
Sorry no solution, but I am having the same problem when I try to read in data from a database. I keep reducing the number of records requested and it keeps crashing,
java.lang.OutOfMemoryError: Java heap space
So it would be nice to have a way to know exactly how many records I should request.
I'm really interested in this subject too. If somebody from TMW can help...
fastinsert 'is known' to be slow...I usually write data to .txt in delimited fmt and import it with the tools suplpied with the database software. Proved to be faster.