Microsoft Access Connector Java Heap Space

[mlauber71]

@mpsz

space parameter is set to: -Xmx4096m

4 GB to process a 1.5 GB table could be a tricky. Also Access is maybe not the best storage if you have other options.

DB Writer to Access DB Hangs at 99%

@qdmt one idea could be to test H2/SQL database: http://h2database.com/html/advanced.html#limits_limitations You could create a new database connection with a current H2 driver (from Maven) and add the “split” parameter to the connection string: jdbc:h2:split:[location=file?<file>][location=in-memory?mem:<database>] [image] You will have to select this new “h2_split” database driver in the H2 Connector instead of the built-in one: [image] The data would then be stored in a local H2/S…