天天看點

java.sql.SQLException: ORA-00903: invalid table name

java.sql.SQLException: ORA-00903: invalid table name

 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)

 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)

 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)

 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212)

 at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:795)

 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030)

 at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:835)

 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123)

 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)

 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328)

 at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

 at dao.ShowDAO.CountMaxPage(ShowDAO.java:58)

 at struts.action.ShowAction.execute(ShowAction.java:56)

 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)

 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)

 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)

 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)

 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(ApplicationFilterChain.java:252)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

 at tool.EncodeFilter.doFilter(EncodeFilter.java:42)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)

 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

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

qqqqqqqqq:select userid,userpassword,phone,email from userbasicinfo where sex=?  where rowum<?  minus select userid,userpassword,phone,email from userbasicinfo where sex=?  where rowum<?

java.sql.SQLException: ORA-00933: SQL command not properly ended

 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)

 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)

 at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)

 at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:212)

 at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:795)

 at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1030)

 at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:835)

 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1123)

 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3284)

 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3328)

 at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

 at dao.ShowDAO.getUserInfo(ShowDAO.java:129)

 at struts.action.ShowAction.execute(ShowAction.java:64)

 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)

 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)

 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)

 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)

 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(ApplicationFilterChain.java:252)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

 at tool.EncodeFilter.doFilter(EncodeFilter.java:42)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)

 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

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

java.lang.NullPointerException

 at dao.ShowDAO.getUserInfo(ShowDAO.java:157)

 at struts.action.ShowAction.execute(ShowAction.java:64)

 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)

 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)

 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)

 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)

 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(ApplicationFilterChain.java:252)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

 at tool.EncodeFilter.doFilter(EncodeFilter.java:42)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)

 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)

 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)

 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)

 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)

 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)

 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)

 at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)

 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)

 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)

 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)

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

解決:

執行的SQL語句有誤

先後順序錯誤

結果集裡沒資料