ERROR XJ001: Java exception: ': java.lang.StackOverflowError'

Question

I am using Derby DB and I am executing simple INSERT statement, well there is around 9000 of rows to be filled in. During that I get the error:

Can anyone help me with some tips please?

Thanks

Remi

Show your query to see what are you trying – Yaroslav Aug 03 '12 at 13:22 — Yaroslav, Aug 03 '12 at 13:22

score 0 · Answer 1 · answered Jun 22 '17 at 02:56

I had the same problem and I find three different ways to solve it:

Use an INSERT command per row.
Split the rows in several INSERT commands with multiple (but less) rows in VALUES clause.
Use the -Xss option to set the thread stack size of the Java Virtual Machine. See here and here for better understanding about this option.

1 Answers1