Access Connector: Java heap space

[mlauber71]

@Awiener glad you found a solution and SQLite is a good choice. If you need an alternative for also large datasets or different type handling H2 is also a nice local option where you can split very large datasets across several local files if necessary.

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…