java.lang.OutOfMemoryError: Java heap space with Microsoft Access database

schaynes — Thu, 05 Apr 2018 10:52:07 GMT

Hi,

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-2.0.9.5.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

Thanks

Re: java.lang.OutOfMemoryError: Java heap space with Microsoft Access database

Anonymous — Thu, 05 Apr 2018 10:58:41 GMT

Can you show us your job layout? You might be able to make it more memory efficient.

Re: java.lang.OutOfMemoryError: Java heap space with Microsoft Access database

schaynes — Thu, 05 Apr 2018 11:11:57 GMT

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"

topic java.lang.OutOfMemoryError: Java heap space with Microsoft Access database in Talend Studio

java.lang.OutOfMemoryError: Java heap space with Microsoft Access database

Re: java.lang.OutOfMemoryError: Java heap space with Microsoft Access database

Re: java.lang.OutOfMemoryError: Java heap space with Microsoft Access database