Question

java程序连接oracle数据库问题 告知下问题出在哪儿了 配置都是没问题的

querySql Exception:
select check_link_id, check_item_id from dc_check_task where check_item_type = 'CHECK_FILES_SEQ' and state = '1' and check_link_id in (
java.sql.SQLException: ORA-00936: missing expression

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)数据路连接问题
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protocol.java:830)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2391)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:572)
at dcm.dbase.DcmDbaseManager.querySql(DcmDbaseManager.java:81)
at x25.check.SeqContext.loadSeqConfig(SeqContext.java:156)
at x25.check.SeqContext.load(SeqContext.java:97)
at x25.check.SeqScanner.run(SeqScanner.java:37)

Answer 1

sql 语句不全， 检查sql语句： 括号后面的语句哪里去了？

Answer 2

sql在数据库执行下。sql错误

追问

日志打印是SQL不全，ORA-00936: missing expression
错误表达式缺失

追答

select check_link_id, check_item_id from dc_check_task where check_item_type = 'CHECK_FILES_SEQ' and state = '1' and check_link_id in (
你的SQL在最后in (xx,xx) 少内容我还以为你是粘的不全。

Answer 3

你把sql在 plsql里面运行下。看看会不会报错。

Answer 4

sql有问题，完整的贴出来。