Out of memory error in JDBC receiver adapter
I am inserting a large data set using a receiver JDBC adapter into a single table in an MSSQL server.
Theoretically I could use statement batch mode to increase throughput. However if I set the batch flag I get an "insufficient system memory to execute this SQL Statement" exception which is apparently being thrown by the jdbc driver.
Question is: Is there a way to allow it to use more memory? Which parameter should be modified and where is it?