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 |
Peter