Error using jc_contains

Hi all,





I'm getting the following error when querying a structure table from within the database:





SELECT cd_id FROM structures WHERE jc_contains(cd_smiles, 'CN1C=NC2=C1C(=O)N(C)C(=O)N2C') = 1





ORA-29902: error in executing ODCIIndexStart() routine


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


Exception: No fingerprint information for JCHEM.STRUCTURES


Run "jcman -t" or check the JChemProperties table for structure tables


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


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


ORA-06512: at line 1





The owner of this table has all permissions, grants and synonyms. And it can query and update structure table from java client api application.





What is the problem?





Thanks.

Please, make sure the JDBC user configured for Tomcat also has the necessary permissions. Please, consult http://www.jchem.com/doc/admin/cartridge.html#server_jdbc for details.