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

最新推荐文章于 2021-04-04 11:01:04 发布
最新推荐文章于 2021-04-04 11:01:04 发布
阅读量1.1k 收藏
点赞数
分类专栏： database 文章标签： Java SQL Oracle Apache Struts

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语句有误
先后顺序错误
结果集里没数据

Mysql报错 Error querying database. Cause java.sql.SQLSyntaxErrorException
m0_67393619的博客
06-08 1万+
今天写一个查询功能的时候，出现了一个错误，当我写好后端接口，准备去前端掉用的时候出现了如下错误：###Errorqueryingdatabase.Cause:java.sql.SQLSyntaxErrorException:YouhaveanerrorinyourSQLsyntax;checkthemanualthatcorrespondstoyourMySQLserverversionfortherightsyntaxtousenear’LIMIT10’atline31###Theerrormayexis
Oracle ora01410,ORA-01410: invalid ROWID
weixin_42129005的博客
04-05 1032
早上维护人员找我，说有个系统，昨天晚上报错ORA-01410: invalid ROWID偶第一个反应是，有用ROWID=xxxx的SQL，但是维护给我说绝对没有于是让他把SQL发给我SELECT SUBSTR(COMP_PRD_INST_ID, 5, 12)FROM (SELECT *FROM F_1_SERV_D PARTITION(P028)WHERE COMP_PROD_FLAG = 0A...
### Cause: java.sql.SQLSyntaxErrorException: ORA-00903: 表名无效
wuChiSha的博客
11-05 3463
第一次开发定时任务，很激动，开发完一运行，果然出现了好多问题，都是写结果一直报表名无效的问题…… 仔细检查了一遍又一遍，表名没错、字段没错、类型也没错，找来大佬帮忙看下，结果，没错呀……百度下吧！ 百度了，大部分都说的是可能是在SQL中多了个"；"之类，可我仔细检查了，并么有呀！ 后来debug下，发现在执行批量插入时，所有的数据都是空的，会不会是…… 经过验证，确实是因为批量插入时，数据为空会导致报报错：### Cause: java.sql.SQLSyntaxErrorException: OR
mybatis查询报错 ORA-00903: 表名无效
IT夜幕的博客
02-02 2795
Mybatis 查询Cause: java.sql.SQLSyntaxErrorException: ORA-00903: 表名无效 起因想通过通用方法加载不同表名查询数据，使用Mybatis查询报错 @Select(" select #{column} as str from #{table} group by #{column} order by count(1) desc ") 将 #{table} 修改为 ${table} 查询数据 @Select(" select #{
mybatis ORA-00903: 表名无效 以及 java中PreparedStatement和Statement详细讲解
红袖添香的博客
07-09 2340
mybatis ORA-00903: 表名无效 <select id= "queryTable" resultMap="map> select * from #{tableName} </select> ### SQL: select * from ? ### Cause: java.sql.SQLException: ORA-00903: 表名无效 发现有问题，实际上#{}方式通过？形式进行传递参数的，？它不支持tableName 将#{}换成${} <...
oracle+ora-各种常见java.sq
06-21
- `java.sql.SQLException: ORA-00942: table or view does not exist`: 查询的表或视图不存在。核实表名或视图名的拼写和大小写，以及是否有访问权限。 6. **并发问题** - `java.sql.SQLException: ORA-00054: ...
oracle 错误 22303,Oracle 12c ADG备库执行sql报错ORA-22303、ORA-16000、ORA-06508、ORA-06512
weixin_42610010的博客
04-04 961
一、背景介绍某客户数据库备库执行sql失败，数据库环境：主库(12.2.0.1 RAC)，备库(12.2.0.1 单机)RAC到单机搭建了ADG，数据是从12.1.0.2通过erp导入的，报错信息：ORA-22303、ORA-16000、ORA-06508、ORA-06512，具体报错内容见下文。二、问题描述1、执行SQL&报错2020-03-03 15:34:32.830 [job-81...
记一次报错ORA-00600: internal error code, arguments: [kdsgrp1]，解决索引坏块问题！
zhongxiayeyu的博客
10-28 6516
记一次报错ORA-00600: internal error code, arguments: [kdsgrp1]，解决索引坏块问题！ 【原创】作者：仲夏夜雨 数据库版本：Oracle 10.2.0.5，RAC集群。 同事找我问数据库问题，客户那边网站点击按添加钮显示error如下图。 现象一： Java程序报错ORA-00600: internal error code, arguments:...
ORA-01410 invalid rowid
ZhangBiao 的专栏
05-28 1万+
最近业务短信经常报出如下异常：     系统错误编码：ORA-01410:无效的ROWID,错误源：PKG_BASE_DATA_XXXX,本地错误信息：TABLE_NAME=T_XXXX_CONN_MAC，错误位置：1-6.      结合业务场景，经分析，是索引失效导致的big query无法检索到正确的数据。表数据是通过sqlldr使用direct方式加载到表中。下面主要分析一下这
java类型名无效_java – ORA-00903：PreparedStatement上的表名无效
weixin_31857829的博客
03-02 411
我有一个方法将执行一个查询,其中包含准备语句的QueryParameters列表. HelperConnection和QueryParameter只是小型的java bean,根据你在这里看到的内容,它应该是不言自明的.我尝试从双重使用中选择*,而不是选择*来自？ QueryParameter是STRING类型,值是dual.但是,我得到一个java.sql.SQLSyntaxErrorExcep...
ora-00903 表名无效
wkx_boda的博客
03-16 1425
添加属性字段备注时报ora-00903 ，查看SQL COMMENT ON COLUMN SECTION_DATA.5_coverage_areaIS '覆盖区域' 查看到SQL中属性命名时，以数字开头，在oracle中属性命名，不要用数字命名，可能会导致无法添加备注，这时对属性用双引号括住时，可以添加备注，切记，不要用数字 或“_”开头 ...
ORA-00903:表名无效
床上鬼见愁的专栏
05-25 4999
是保留字
Oracle查询表名为User的表时报ORA-00903:表名无效
热门推荐
ey
10-04 1万+
原因：oracle内部已使用USER表 解决方法： select * from "数据库名"."USER"
java.sql.SQLSyntaxErrorException: ORA-00933:
zhanghaisong_2015的博客
09-11 3108
问题描述： Written [{"code":-900,"data":"","desc":"org.springframework.jdbc.BadSqlGrammarException: \r\n### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束\n\r\n#...
mybatis ORA-00903: 表名无效
tornado430的专栏
10-10 6465
  参考于：http://blog.51cto.com/11230344/2287968 &lt;select id= "queryTable" resultMap="map&gt;     select * from #{tableName}   &lt;/select&gt; ### SQL: select * from ? ### Cause: java.sql.SQLExceptio...
nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
m0_46953020的博客
03-23 1502
String table_name = "PF_ACTIVITY_SCORE "; String table_fields = "(OID,PF_PROJECT_NAME,PF_PROJECT_OID,SCORE,CREATE_TIME,PSY_CPR_OID)"; String table_values_list = "<if test=\"pd.list != null and pd.list != ''\"> " + "select a.* from...
Mybatis发生异常： Cause: java.sql.SQLException: ORA-00911: 无效字符
分享我的点点滴滴，在成长路上与你同行！
07-27 1045
Mybatis运行发生异常： Cause: java.sql.SQLException: ORA-00911: 无效字符   原因是：你的sql多了一个";" 去掉就可以了~ select count(1) from table_ip; 解决方法：去掉“;” select count(1) from table_ip
oracle错误ORA_00903,Oracle ORA-00903错误具体原因分析
weixin_39987926的博客
04-03 7223
ORA-00903 invalid table nameORA-00903：无效的表名Cause A table or cluster name is invalid or does not exist. This message is also issued if an invalid cluster name or no cluster name is specified in an ALTE...
java.sql.SQLException: ORA-00911: 无效字符
最新发布
04-17
java.sql.SQLException: ORA-00911: 无效字符 是一个Java中的异常，它表示在执行SQL语句时遇到了无效的字符。具体来说，ORA-00911错误通常是由于在SQL语句中使用了不被数据库支持的特殊字符或者关键字导致的。 要...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值