java.sql.SQLException: ORA-00911: invalid character

错误信息如下:

 

 select * from cs_menu;

java.sql.SQLException: ORA-00911: invalid character

 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
 at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
 at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
 at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1451)
 at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:651)
 at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2117)
 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2331)
 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:422)
 at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:366)
 at Tree.TreeUtil.retrieveNodeInfos(TreeUtil.java:47)
 at taglibs.InitTreeTag.doEndTag(InitTreeTag.java:32)
 at _jsp._left__jsp._jspService(_left__jsp.java:37)
 at com.caucho.jsp.JavaPage.service(JavaPage.java:60)
 at com.caucho.jsp.Page.pageservice(Page.java:570)
 at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:159)
 at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:178)
 at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229)
 at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:268)
 at com.caucho.server.port.TcpConnection.run(TcpConnection.java:389)
 at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
 at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
 at java.lang.Thread.run(Thread.java:595)
java.sql.SQLException: ORA-00911: invalid character

 

 

SQL语句多了个“;”    ,去掉分号就可以了,这样的错误,汗···

评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值