ORA-04092 after upgrading to JChem 5.3.1

ChemAxon aa7c50abf8

11-03-2010 16:41:32

We are in the midst of upgrading a current cartridge customer to 5.3.1 from a much earlier version. We have an Oracle before insert trigger that calculates the molecular weight,formula, and exact mass for an incoming molfile as it is being registered.

-- :NEW.MOLWEIGHT := JCF.MOLWEIGHT(:NEW.COMPOUND);
-- :NEW.FORMULA := JCF.FORMULA(:NEW.COMPOUND); 
-- :NEW.EXACTMASS := JCF.EVALUATE(:NEW.COMPOUND,'exactMass');

With 5.3.1, we get the following error whenever we fire the trigger with any of these functions included:

ORA-29532: Java call terminated by uncaught Java exception:
oracle.jdbc.driver.OracleSQLException: ORA-04092: cannot COMMIT in a trigger
ORA-06512: at "JCHEM.JCHEM_BLOB_PKG", line 123
ORA-06512: at "JCHEM.JCF", line 409

This is a symptom of the same bug as underlies to the problem reported here. The fix will be included in the JChem version schedule for release end of March.


Sorry for the inconvenience.


Peter