Invalid index?

ChemAxon aa7c50abf8

08-05-2006 15:50:23

inhibox wrote:
The index below does appear to have been created/is valid (when subsequently inspect table)but I don't know if this is really the case - I suspect not?








JCHEM_CORE_PKG.GETENVIRONMENT()


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


Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production


PL/SQL Release 9.2.0.1.0 - Production


CORE 9.2.0.1.0 Production


TNS for 32-bit Windows: Version 9.2.0.1.0 - Production


NLSRTL Version 9.2.0.1.0 - Production


NLSRTL Version 9.2.0.1.0 - Production


JChem version in the database: TEST_2006_04_19


JChem version in the Tomcat server: TEST_2006_04_19


java.vm.version: 1.4.2_04-b05


java.vm.vendor: Sun Microsystems Inc.


Apache Tomcat/5.0.28





JCHEM_CORE_PKG.GETENVIRONMENT()


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


Major JDBC version in Tomcat: 1


Minor JDBC version in Tomcat: 0








SQL> CREATE INDEX testamidereactantaJCIdx ON testamidereactanta (smiles) INDEXTYPE IS jc_idxtype


2 PARAMETERS ('JChemPropertiesTable=JchemProperties2,debuglevel=1');


CREATE INDEX testamidereactantaJCIdx ON testamidereactanta (smiles) INDEXTYPE IS jc_idxtype


*


ERROR at line 1:


ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine


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


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


servlet:


Exception: Please, check the JDBC connection properties for Tomcat.


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


ORA-06512: at "REACTOR.JC_IDXTYPE_IM", line 17
The JDBC connection properties in Tomcat are likely to be wrong/missing. Please, point your WEB-browser to the JChemStreams URL and check the JDBC connection properties (as the error message suggests).





Peter

ChemAxon 60ee1f1328

09-05-2006 12:31:07

Peter,





That has fixed the index creation issue...





Thanks,


Daniel.