drop objects cause an error

I get the below errors when attempting to create a jcidx on a non-jchem table...None of these objects are referenced in jchemproperties table


or exist in Oracle at index creation time and so is it possible to check this before the drops are attempted? I'm not sure where the information that they do exist is coming from?





2006-05-16 09:45:16.556 [UNKNOWN]: Failing statement: DROP TABLE REACTOR.TESTAMI


DEAJCIDX_jcx


2006-05-16 09:45:16.556 [UNKNOWN]: Failing statement: DROP SEQUENCE REACTOR.TEST


AMIDEAJCIDX_jcx_SQ


2006-05-16 09:45:16.571 [UNKNOWN]: Failing statement: DROP TRIGGER REACTOR.TESTA


MIDEAJCIDX_jcx_TR


2006-05-16 09:45:16.571 [UNKNOWN]: Failing statement: DROP TABLE REACTOR.TESTAMI


DEAJCIDX_jcx_UL


2006-05-16 09:45:16.587 [UNKNOWN]: Failing statement: DROP SEQUENCE REACTOR.TEST


AMIDEAJCIDX_jcx_USQ


2006-05-16 09:45:16.602 [UNKNOWN]: Failing statement: DROP TABLE REACTOR.TESTAMI


DEAJCIDX_jsu


java.sql.SQLException: ORA-00942: table or view does not exist





at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)


at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)


at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)


at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)


at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:109


3)


at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja


va:2047)


at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav


a:1940)


at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme


nt.java:2709)


at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar


edStatement.java:589)


at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStat


ement.java:656)


at chemaxon.jchem.cartridge.JFunctions.execDDLStatement(JFunctions.java:


4504)


at chemaxon.jchem.cartridge.Indexing.dropIdxUpdateSuspendLogTable(Indexi


ng.java:479)


at chemaxon.jchem.cartridge.Indexing.indexDrop(Indexing.java:552)


at chemaxon.jchem.cartridge.servlets.JChemCartIndex.createInitIndexTable


(JChemCartIndex.java:55)


at chemaxon.jchem.cartridge.servlets.JChemCartIndex.buildIndex(JChemCart


Index.java:244)


at chemaxon.jchem.cartridge.servlets.JChemCartTunnel.process(JChemCartTu


nnel.java:54)


at chemaxon.jchem.cartridge.servlets.JChemServletBase.doPost(JChemServle


tBase.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(Appl


icationFilterChain.java:237)


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF


ilterChain.java:157)


at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV


alve.java:214)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv


eContext.java:104)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav


a:520)


at org.apache.catalina.core.StandardContextValve.invokeInternal(Standard


ContextValve.java:198)


at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV


alve.java:152)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv


eContext.java:104)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav


a:520)


at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j


ava:137)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv


eContext.java:104)


at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j


ava:118)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv


eContext.java:102)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav


a:520)


at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal


ve.java:109)


at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValv


eContext.java:104)


at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.jav


a:520)


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





at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:16


0)


at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java


:799)


at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce


ssConnection(Http11Protocol.java:705)


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


:577)


at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP


ool.java:683)


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

and of course the answer is the jc_idx_property table...


Cheers,


Daniel.

Hi Daniel,

Quote:

2006-05-16 09:45:16.556 [UNKNOWN]: Failing statement: DROP TABLE REACTOR.TESTAMI DEAJCIDX_jcx 2006-05-16 09:45:16.556 [UNKNOWN]: Failing statement: DROP SEQUENCE REACTOR.TEST AMIDEAJCIDX_jcx_SQ 2006-05-16 09:45:16.571 [UNKNOWN]: Failing statement: DROP TRIGGER REACTOR.TESTA MIDEAJCIDX_jcx_TR ...

I guess these traces come from <tomcat-home>/logs/catalina.out, correct?





What kind of error messages appear on the Oracle end?





Cheers


Peter