java.sql.SQLException: java.lang.OutOfMemoryError: Java heap space

Asked Aug 19 '19 at 20:31

Active Aug 19 '19 at 20:31

Viewed 970 times

I have Java code that creates a MySQL database connection, and then processes a text file line-by-line. For each line (string), it parses it and creates a PreparedStatement that gets executed. The PreparedStatement inserts a new entry in a table in the database that I connected to.

My file contains thousands of lines, and I get this error: java.sql.SQLException: java.lang.OutOfMemoryError: Java heap space. How do I do this kind of operation more memory-efficiently? I've read about making a batch of MySQL statements and then executing the batch. Would that be helpful for my situation?

asked Aug 19 '19 at 20:31

Software Dev

1

Do you really create new PreparedStatement for each line instead of create PreparedStatement once and set it's parameters lint by line? – Bor Laze Aug 19 '19 at 20:34
Yes, I do. How would I execute multiple INSERT statements with one PreparedStatement? – Software Dev Aug 19 '19 at 20:36
2

Add your code to question – Bor Laze Aug 19 '19 at 20:42
2

You can create a single PreparedStatement (with `?` parameters) and then reuse it for thousands of rows. Just set the different values each time and run it. – The Impaler Aug 19 '19 at 20:47
Check this - looks like it contains answer for your question: https://stackoverflow.com/questions/11971635/creation-of-a-prepared-statement-inside-a-loop – Bor Laze Aug 19 '19 at 20:49
Can you post some code/examples? – Aug 19 '19 at 21:39

java.sql.SQLException: java.lang.OutOfMemoryError: Java heap space

0 Answers0