jc_standardize with xml configuration

User d90f4e1cc8

13-02-2012 09:15:06

Hello,


When I try to use the cartridge function jc_standardize with xml configuration I get the following error message:


ORA-29532: Java call terminated by uncaught Java exception: java.lang.IllegalArgumentException: Illegal option: version="1.0"
ORA-06512: at "JCHEM.JCHEM_CORE_PKG", line 411
ORA-06512: at "JCHEM.STANDARDIZE_FUNC", line 12


Example call:


select jc_standardize('[Ca++].CCCCC','config:<?xml
version="1.0"
encoding="UTF-8"?><StandardizerConfiguration><Actions><Removal
ID="keepOne" Method="keepLargest"
Measure="atomCount"/></Actions></StandardizerConfiguration>')
from dual;


 


Environment:


Oracle environment:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0    Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production

JChem Server environment:
Java VM vendor: Sun Microsystems Inc.
Java version: 1.6.0_13
Java VM version: 11.3-b02
JChem version: 5.8.1
JChem Index version: 5080100
JDBC driver version: 11.1.0.7.0-Production


 


Best regards,


Mike

ChemAxon aa7c50abf8

13-02-2012 17:17:43

Hi Mike,


The second parameter is an option list: http://www.chemaxon.com/jchem/doc/dev/cartridge/index.html#option_list_parameter .


The option separator has to be explicitly set, like in:


 


SQL> select jc_standardize('[Ca++].CCCCC','sep=~~~~!!!! config:<?xml version="1.0" encoding="UTF-8"?><StandardizerConfiguration><Actions><Removal ID="keepOne" Method="keepLargest" Measure="atomCount"/></Actions></StandardizerConfiguration>') from dual;


JC_STANDARDIZE('[CA++].CCCCC','SEP=~~~~!!!!CONFIG:<?XMLVERSION="1.0"ENCODING="UT


--------------------------------------------------------------------------------


CCCCC


SQL>


Peter

User d90f4e1cc8

14-02-2012 05:41:38

Hi Peter,


 


Thank you very much for your help.


 


Mike