Table Update with jcman: OutOfMemoryError

Hi,

I'm updating the Chemaxon tables in a large MYSQL database.

I'm using the command line interface of the the JChem Manager to do it (latest version, 14.7.21.0, in a Linux environment):

./bin/jcman u -dburl jdbc:mysql ... etc.

The first part went fine, but the Chemical Terms data update threw this error:

chemaxon.jchem.db.Regenerator$RegenThread run

SEVERE: java.lang.OutOfMemoryError: Java heap space

Exception in thread "main" java.lang.OutOfMemoryError: Java heap space

        at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2222)

How do I set jcman to use a larger heapspace? There's nothing in the docs related to memory.

Cheers,

Brendan

Nevermind - resolved. I didn't realise jcman was a script, but I found the setting in there.

Cheers,

Brendan

Hi Brendan,

 

I am happy to see that you've solved the issue.

We have a documentation about our experience related to the heap size needed by our search applications:

https://docs.chemaxon.com/display/jchembase/JChem+Base+and+Cartridge+Performance+Information

 

Best regards,

Norbert