I'm trying to load data from MS Access 2000 databases with Tand Open Studio (6.3.1)
I have about 100 Access database to load each night
(fortunatly each database has the same exact structure)
So, i have build an unique job and use a context to modifiy the file name and the path of the .MDB file
It works perfect ; but time to time I have this error on the console :
Exception in thread "Thread-610" java.lang.OutOfMemoryError: Java heap space
java.lang.OutOfMemoryError: Java heap space
I have read many hints on internet about this problem
What I have tried so far :
- I check that "memory=false" is specified in the additionnals parameters of Access connection
- I have improve memory with "-Xms1024M" and "-Xmx4096M" in the "TOS_DI-win-x86_64.ini" file and in the Preferences > Talend > Run/Debug
What can I do more ?
In the view "Module" i can see the module "ucanaccess-220.127.116.11.jar" but on the ucanaccess website (http://ucanaccess.sourceforge.net/site.html) I can see that the last version is 4.0.3. ? Anyway to upgrade the Talend module ?
Any help will be welcome
OK, it look like this
For each table tAccessInput -> tMap -> tPostgresqlOutput
in the tAccessInput, Property Type is in "Built-In" with Database specified by context. In advanced settings, additional JDBC Parameters "memory=false"