当前位置: 代码迷 >> 高性能WEB开发 >> ORA-00942: table or view does not exist,该怎么解决
  详细解决方案

ORA-00942: table or view does not exist,该怎么解决

热度:1156   发布时间:2012-03-15 11:50:38.0
ORA-00942: table or view does not exist
10/02/25 09:39:01 ORA-00942: table or view does not exist

10/02/25 09:39:01 java.sql.SQLException: ORA-00942: table or view does not exist

10/02/25 09:39:01 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
10/02/25 09:39:01 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
10/02/25 09:39:01 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
10/02/25 09:39:01 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
10/02/25 09:39:01 at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:112)
10/02/25 09:39:01 at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:430)
10/02/25 09:39:01 at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1003)
10/02/25 09:39:01 at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:462)
10/02/25 09:39:01 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1109)
10/02/25 09:39:01 at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4005)
10/02/25 09:39:01 at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4039)
10/02/25 09:39:01 at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1276)
10/02/25 09:39:01 at com.evermind.sql.FilterStatement.executeQuery(FilterStatement.java:154)
10/02/25 09:39:01 at com.evermind.sql.FilterStatement.executeQuery(FilterStatement.java:154)
10/02/25 09:39:01 at com.evermind.sql.StatementBCELProxy.executeQuery(StatementBCELProxy.java:38)
10/02/25 09:39:01 at db.ConDB.executeQuery(ConDB.java:89)
10/02/25 09:39:01 at _docs._jsp._ms__board._INLINE__MONITORING__new._jspService(_INLINE__MONITORING__new.java:157)
10/02/25 09:39:01 at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
10/02/25 09:39:01 at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:350)
10/02/25 09:39:01 at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509)
10/02/25 09:39:01 at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413)
10/02/25 09:39:01 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
10/02/25 09:39:01 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:824)
10/02/25 09:39:01 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:330)
10/02/25 09:39:01 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
10/02/25 09:39:01 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:224)
10/02/25 09:39:01 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:133)
10/02/25 09:39:01 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
10/02/25 09:39:01 at java.lang.Thread.run(Thread.java:534)


你好:
  请问以上是什么问题,声明:
首先画面刷新一次二次都没有问题,当高负荷,高频率刷新时,会报如上错误,请高手指点.
谢谢....





------解决方案--------------------
table or view does not exist 

表示数据库的表或视图不存在

主要问题提示在
_docs._jsp._ms__board._INLINE__MONITORING__new._jspService(_INLINE__MONITORING__new.java:157) 
是web容器吧,在出错的时候查找_INLINE__MONITORING__new.java
看看他的157行是什么
------解决方案--------------------
估计这是你JSP里面有数据库操作,看看你的SQL有什么问题,。
  相关解决方案