Upgrade to JChem3.1.7 - ORA-29532

User 7b0ee04e66

09-06-2006 10:10:14

Good morning,





We have upgraded our test server to 3.1.7 and found the problems below





select jc_standardize('COC1=CC=C(F)C=C1B(O)O','stdConfig:aromatize') from dual;





ORA-29532: Java call terminated by uncaught Java exception: java.lang.IllegalArgumentException: Illegal option: stdConfig


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 0


ORA-06512: at "JCHEM.STANDARDIZE_FUNC", line 12





SELECT jc_react('[C:1](=[O:2])[Cl:3].[H:99][N:4]([H:100])[C:0]>>[C:1](=[O:2])[N:4]([H:100])[C:0].[Cl:3][H:99]', 'CC(C)N.ClC(=O)c1ccccc1', 'method:a') products FROM DUAL





ORA-29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException: The following exception has been thrown by the servlet:


Exception: Number of reactants should be 2 instead of 1.


ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 0


ORA-06512: at "JCHEM.REACT_FUNC", line 11





jc_molweight works fine


jc_contains works fine





The same select commands are fine on our live server (3.1.1)


Do you have any ideas on how to fix this problem?





Thanks


Catherine

ChemAxon aa7c50abf8

09-06-2006 18:04:27

Good Afternoon,
Quote:
select jc_standardize('COC1=CC=C(F)C=C1B(O)O','stdConfig:aromatize') from dual;
Use
Code:
select jc_standardize('COC1=CC=C(F)C=C1B(O)O','config:aromatize') from dual;



instead. (The stdConfig option was also accepted in earlier versions, but in the documentation it has always been referred to as config as far as I could check.)


Quote:



SELECT jc_react('[C:1](=[O:2])[Cl:3].[H:99][N:4]([H:100])[C:0]>>[C:1](=[O:2])[N:4]([H:100])[C:0].[Cl:3][H:99]', 'CC(C)N.ClC(=O)c1ccccc1', 'method:a') products FROM DUAL





ORA-29532: Java call terminated by uncaught Java exception: java.lang.RuntimeException: The following exception has been thrown by the servlet:


Exception: Number of reactants should be 2 instead of 1.
This is a bug. It will be fixed in the next JChem release. Thank you for reporting it.





Best Regards,


Peter

User 7b0ee04e66

12-06-2006 08:25:07

Thanks it works now


Catherine