why this error with jc_equals?

Help, Cheers Daniel.





Build: TEST_2006_05_17





SQL> CREATE INDEX buildv3JCIdx


2 ON BUILDV3 (cd_smiles) INDEXTYPE IS jc_idxtype


3 PARAMETERS('JChemPropertiesTable=JchemProperties,debuglevel=1');





Index created.





Elapsed: 00:00:00.00








After call to jc_equals or jc_compare ('t:e')





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: The table JCHEM3.BUILDV3 doesn't exist or size of fingerprint is not properly set in property table "JchemProperties".


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


ORA-06512: at "JCHEM3.JC_IDXTYPE_IM", line 184


ORA-06512: at line 1





<all data appears to be in order in jchemproperties and jc_idx_property>





catalina.out





java.sql.SQLException: The table JCHEM3.BUILDV3 doesn't exist or size of fingerprint is not properly set in property table "JchemProperties".


at chemaxon.jchem.db.FingerprintHandler.getNumberOfBits(FingerprintHandler.java:47)


at chemaxon.jchem.db.JChemSearch.initTable(JChemSearch.java:2487)


at chemaxon.jchem.db.JChemSearch.init(JChemSearch.java:2781)


at chemaxon.jchem.db.JChemSearch.search1(JChemSearch.java:2089)


at chemaxon.jchem.db.JChemSearch.search(JChemSearch.java:1989)


at chemaxon.jchem.db.JChemSearch.setRunning(JChemSearch.java:1871)


at chemaxon.jchem.db.JChemSearch.run(JChemSearch.java:1891)


at chemaxon.jchem.interop.core.InteropJChemSearch.run(InteropJChemSearch.java:413)


at chemaxon.jchem.interop.core.InteropJChemSearch.search0(InteropJChemSearch.java:364)


at chemaxon.jchem.interop.core.InteropJChemSearch.search(InteropJChemSearch.java:332)


at chemaxon.jchem.interop.core.InteropJChemSearch.search(InteropJChemSearch.java:301)


at chemaxon.jchem.cartridge.servlets.JChemCached.doSearch(JChemCached.java:532)


at chemaxon.jchem.cartridge.servlets.JChemCached.doPerform(JChemCached.java:325)


at chemaxon.jchem.cartridge.servlets.JChemCached.process(JChemCached.java:84)


at chemaxon.jchem.cartridge.servlets.JChemServletBase.doPost(JChemServletBase.java:232)


at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)


at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)


at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)


at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)


at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)


at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)


at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)


at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)


at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)


at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)


at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)


at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)


at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)


at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)


at java.lang.Thread.run(Thread.java:534)

Hi Daniel,





This message indicates that no JChem table called "buildv3JCIdx" is registered with the jchemproperties table called "JchemProperties" (in the schema of the caller).





Cheers,





Peter

Hi Peter,





There is no table called buildv3JCIdx, this is the name of the JCindex created on the table buildv3. Why is it apparently looking for a table using the index name?





Code below works fine:





select jcf_standardize(cd_smiles,'config:keepone..aromatize..removeexplicitH..[O:2]=[N:1]=O>>[O-:2][N+:1]=O..N=[N:1]#[N:2]>>N=[N+:1]=[N-:2]..[H:4][O:3][C:1]=[C:2]>>[H:4][C:2][C:1]=[O:3]..[H:4][N:3][C:1]=[C:2]>>[H:4][C:2][C:1]=[N:3]..[#6][CH1:3]([#6])[N:1]=[O:2]>>[#6][CH0:3]([#6])=[N:1][#8H1:2]..[H:4][n:3]:[c:1]=[O:2]>>[O:2]-[c:1]:[n:3]..[O:2]=[N:1]=O>>[O-:2][N+:1]=O')


from buildv3





These two SQL cause the error described above





select * from buildv3 where jc_equals (cd_smiles,'[O-][N+](=O)c1ccccc1')=1





select * from buildv3 where jc_equals (cd_smiles,'O=N(=O)C1=CC=CC=C1')=1





Meta data for table BUILDV3 does exist in the jchemproperties table...





Any further suggestion?





Cheers,


Daniel.

Hi Daniel,





Sorry for typo in my previous post. I meant the "buildv3" table, not the index.





The most probable source of this problem is that the database session in Tomcat is running under a user id different from the one where the jc_equals search was initiated.





Is there a user id configured for the JDBC connection in Tomcat?





Cheers,





Peter

Hi Peter,





Yes, I had this set to another user for some other testing work via the jchemstreams/edit.jsp interface - changing back to correct user has allowed the query to complete successfully...





Cheers,


Daniel.