setIgnoreChemicalTermsExceptions has no effect

User 0261d34ad7

13-03-2012 17:35:55

Hi,

We're using ChemAxon 5.7.0, and finding that the setIgnoreChemicalTermsExceptions() method on the UpdateHandler is not working as expected.

Specifically, we're attempting to insert chemical properties that include query elements. These cause problems for our chemical property calculators but rather than swallowing the exception(which we want) the UpdateHandler is throwing a SQLException.

Here's an example of the kind of error we're seeing:

: Error while evaluating expression:

rotatableBondCount()

Calculation result is not defined for query molecules: [#6]C([#6])CC(C([#6])[#6])[Si](OC([#6])[#6])(OC([#6])[#6])C([#6])[#6] |w:17.17,17.18,10.10,10.11,14.14,14.15,5.5,5.6,1.0,1.1,LN:9:1.5|, expression: rotatableBondCount()

And another (actually from the same error output):

: Error while evaluating expression:

donorCount()

Calculation result is not defined for query molecules: [#6]C([#6])CC(C([#6])[#6])[Si](OC([#6])[#6])(OC([#6])[#6])C([#6])[#6] |w:17.17,17.18,10.10,10.11,14.14,14.15,5.5,5.6,1.0,1.1,LN:9:1.5|, expression: donorCount()

Mar 13, 2012 4:34:22 PM chemaxon.jchem.db.UpdateHandler calcChemTermColValues

etc etc - I have lots more output if required.

Any help appreciated.

J

ChemAxon afdac7b783

15-03-2012 06:22:23

Dear James,

we have a long weekend due to our national holiday here, but we will reply you as soon as possible.

Best Regards,
Viktoria

User 0261d34ad7

15-03-2012 07:54:42

Thanks. Please note that this is fairly urgent for us so any information you can provide is appreciated.

J

User 0261d34ad7

15-03-2012 12:13:42

Just a quick update - I think we got this wrong, I've just spent some time reviewing our logs and I think I misread what was happening, so we're good I believe.