java中 jdbc报错 ORA-00911: 无效字符

来源：互联网发布：论校园网络的设计思路编辑：程序博客网时间：2024/05/01 23:36

Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)    at Temp.main(Temp.java:18)

" select empno,ename,job from emp";前后空格删除了　　还有sql语句的最后有没有多写了一个分号（；）　　就是这两种情况会引起Exception in thread "main" java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符的

0 0