JChem cartridge query problem

HI,





I was able to fix the index problem in my previous post by using jchem manager to create and import a table with smiles. When I tried to query it using sql like:





select cd_id,cd_smiles from molecules where jchem.jc_contains(cd_smiles,'COCc1ccco1')=1





I got error:





ERROR at line 1:


ORA-29902: error in executing ODCIIndexStart() routine


ORA-29532: Java call terminated by uncaught Java exception:


java.lang.RuntimeException: The following exception has been thrown by the


servlet:


Exception: null


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


ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 167


ORA-06512: at line 1








If I do





select jc_contains(cd_smiles,'') from molecules





it worked fine.





Thanks in advance for help.





Yuhong Wang





wangyuh _at_ mail.nih.gov

Please, could you post the Java stack trace that can be found in <tomcat-home>/logs/catalina.out?





Please, could you also specify which JChem version you are using?





Peter

Hi Peter,





Thanks for your reply.





THis morning, I updated the version to 3.1.1, but it worked now. It seems to be a bug, fixed in 3.1.1.





Thanks again for your help.





Yuhong