ORA-00942

User 4140faeba5

06-09-2005 08:31:12

Hi.





When I try to access a database I get the following from Oracle.





C:\hivedev>bee jchem.bee


--> M:\\.beehiverc.WS18693


Error> 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: ORA-00942: table or view does not exist


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


ORA-06512: at "JCHEM.JC_IDXTYPE_IM", line 449 (jchem.bee:628)


Error> 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: ORA-00942: table or view does not exist


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


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


(jchem.bee:628)


Error> error while running 'ExecSql(string("select count(cd_id) from ACCS...))'


(jchem.bee:628)





How do I find out wich table lacks the right grants ?





/Mikael

ChemAxon aa7c50abf8

06-09-2005 08:52:39

Please, could you post the stack trace for the last exception (should contain the message: "Exception: ORA-00942: table or view does not exist") in <tomcat-home>/logs/catalina.out.





Peter

User 4140faeba5

06-09-2005 09:03:31

Here is catalina.out.


The very last lines just confirmes I restarted the server.


/Mikael

ChemAxon aa7c50abf8

06-09-2005 09:12:18

The JDBC connection in Tomcat "does not see" the jchemproperties table. The user of the JDBC connection in Tomcat has probably insufficient privileges. How did you configure the JDBC connection in Tomcat. Do you, maybe, use the jchem_core_pkg.use_password() stored procedure?





Peter

User 4140faeba5

06-09-2005 10:12:42

The user has "select any table" privs.





I recreated the index and restarted tomcat, after that it worked.





/Mikael