SQLSyntaxErrorException ORA-00933在使用get查询获取数据时。

24 浏览
0 Comments

SQLSyntaxErrorException ORA-00933在使用get查询获取数据时。

以上代码片段抛出以下异常:

Caused by: java.sql.SQLSyntaxErrorException: ORA-00933: SQL命令未正确结束

[exec] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

[exec] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

[exec] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

[exec] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

[exec] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

[exec] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

[exec] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

[exec] at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

[exec] at java.lang.Thread.run(Thread.java:745)

[exec] at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)

[exec] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)

[exec] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)

[exec] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

[exec] at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)

[exec] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)

[exec] at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)

不确定哪里出错了,我尝试将准备好的语句打印为查询以了解问题,但它没有在系统输出中打印。有人可以帮忙解决这个问题吗?

提前感谢。

0