Question

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

Connection conn=null;
PreparedStatement psmt = null;

Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL,DBUSER,DBPASS);
String sql = " select empno,ename,job from emp";
psmt= conn.prepareStatement(sql);
ResultSet rs = psmt.executeQuery();
最后一句话报错，sql试了没错，怎么查也查不出来呀

下面是报错信息

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)

Answer 1

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

Answer 2

String sql = " select empno,ename,job from emp"; 前后空格删了。sql没错肯定是这句话拼的时候出错了。

Answer 3

解决没？还没解决试试把数据库列job换个名字，不知道job是不是关键字

Answer 4

全部重新写试试，换其他语句执行试试