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

最新推荐文章于 2024-01-10 10:23:50 发布
最新推荐文章于 2024-01-10 10:23:50 发布
阅读量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语句有误
先后顺序错误
结果集里没数据

zjx2388
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
java.sql.SQLSyntaxErrorException问题常见解决方案：比如Table xxx doesn‘t exist；Unknown column ‘xxx‘ in ‘where...
念兮为美
08-15 1万+
解决 bad SQL grammar [xxx]; nested exception is java.sql.SQLSyntaxErrorException: 1. Table xxx doesn't exist 2. You have an error in your SQL syntax；3. Unknown column x in x 4.Unknown column 'xxx' in 'where clause'。
java.sql.SQLException: 内部错误: Unable to construct a Datum from the specified input
01-21
Q: I am working with Oracle database 8.1.7 and I have written a JAVA code to update the table which contains one BLOB field . I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
解决bad SQL grammar []； nested exception is java.sql.SQLSyntaxErrorException
最新发布
qq_47450919的博客
01-10 5019
在使用Spring Boot连接MySQL数据库时，有时候会遇到“Bad SQL Grammar”错误，这种错误通常在执行SQL语句时发生。本文针对的是对于执行多条SQL语句的情况。
mybatis查询报错 ORA-00903: 表名无效
IT夜幕的博客
02-02 2633
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 #{
### Cause: java.sql.SQLSyntaxErrorException: ORA-00903: 表名无效
wuChiSha的博客
11-05 3349
第一次开发定时任务，很激动，开发完一运行，果然出现了好多问题，都是写结果一直报表名无效的问题…… 仔细检查了一遍又一遍，表名没错、字段没错、类型也没错，找来大佬帮忙看下，结果，没错呀……百度下吧！ 百度了，大部分都说的是可能是在SQL中多了个"；"之类，可我仔细检查了，并么有呀！ 后来debug下，发现在执行批量插入时，所有的数据都是空的，会不会是…… 经过验证，确实是因为批量插入时，数据为空会导致报报错：### Cause: java.sql.SQLSyntaxErrorException: OR
Oracle利用errorstack追踪tomcat报错ORA-00903 无效表名的问题
01-19
现象 tomcat错误日志断断续续报ORA-00903: invalid table name，并无具体SQL与表名，需要排查哪段代码写入了无效表名， 可以通过ORACLE提供的errorstack追踪报错SQL。 由于生产数据无法取出，以下皆为测试环境测试还原生产错误。 errorstack简介 设置errorstack，在发生特定的ORA错误时会记录发生问题的会话，语句以及各个进程的trace文件， 在alert日志中有记录错误记录的trace文件位置，也可以给单独会话开启errorstack，追踪会话报错信息，可以通过 下面两个方法开启： /* level 0 仅转储错误堆栈 /* 
mybatis ORA-00903: 表名无效 以及 java中PreparedStatement和Statement详细讲解
红袖添香的博客
07-09 2185
mybatis ORA-00903: 表名无效 <select id= "queryTable" resultMap="map> select * from #{tableName} </select> ### SQL: select * from ? ### Cause: java.sql.SQLException: ORA-00903: 表名无效 发现有问题，实际上#{}方式通过？形式进行传递参数的，？它不支持tableName 将#{}换成${} <...
解决bad SQL grammar []； nested exception is java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符
热门推荐
愿我如星君如月 ... 夜夜流光相皎洁 ...
04-19 18万+
1. 报错： ### Cause: java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符 2.出错 原因： 1) sql在数据库执行都是OK的。 真...
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK
09-29
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK ……
java.sql.SQLException: null,  message from server: “Host ‘%’ is not allowed to connect to
12-14
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错： 解决方法： 1，登陆服务器 mysql> use mysql; //用mysql ...
java.sql.SQLException: 结果集已耗尽
08-02
NULL 博文链接：https://listen-raining.iteye.com/blog/1962065
解决Exception java.sql.SQLException ORA-00600 内部错误代码
07-29
在oracle里面运行一下，解决Exception java.sql.SQLException ORA-00600 内部错误代码
ORA-00900: 无效 SQL 语句（错误原因之一）
yangsen251024的专栏
02-18 13万+
刚试了下joffice的安装，SQL报错：ORA-00900: 无效 SQL 语句 SQL语句如下，查了半天，发现错误原因是由于换行引起的，标记下！ CREATE TABLE OUT_MAIL ( MAILID NUMBER(18) NOT NULL, UIDNO VARCH
oracle错误ORA_00903,Oracle ORA-00903错误具体原因分析
weixin_39987926的博客
04-03 6840
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类型名无效_java – ORA-00903：PreparedStatement上的表名无效
weixin_31857829的博客
03-02 363
我有一个方法将执行一个查询,其中包含准备语句的QueryParameters列表. HelperConnection和QueryParameter只是小型的java bean,根据你在这里看到的内容,它应该是不言自明的.我尝试从双重使用中选择*,而不是选择*来自？ QueryParameter是STRING类型,值是dual.但是,我得到一个java.sql.SQLSyntaxErrorExcep...
Oracle ORA-00903错误具体原因分析
fjnu105022004005的专栏
04-11 3508
 ORA-00903 invalid table name　　ORA-00903：无效的表名　　Cause A table or cluster name is invalid or does not exist. Thismessage is also issued if an invalid cluster name or no cluster name isspecified
ora-00903 表名无效
wkx_boda的博客
03-16 1315
添加属性字段备注时报ora-00903 ，查看SQL COMMENT ON COLUMN SECTION_DATA.5_coverage_areaIS '覆盖区域' 查看到SQL中属性命名时，以数字开头，在oracle中属性命名，不要用数字命名，可能会导致无法添加备注，这时对属性用双引号括住时，可以添加备注，切记，不要用数字 或“_”开头 ...
java.sql.SQLException: ORA-01017: invalid username/password;
08-23
java.sql.SQLException: ORA-01017: invalid username/password异常是Oracle数据库连接时的一个常见错误。它表示使用的用户名或密码是无效的。 这个问题通常是由以下几种情况引起的： 1. 输入的用户名或密码不正确...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值