informix的SQL语句执行出现语法错误的问题,只是一个简单的单表查询的SQL语句:SELECT first 10 callingnumber FROM smp.u_uvc_logonuser
在程序里会把这个语句打印出来,这它复制到informix 客户端上,能够执行成功,但是在程序里用JDBC调用执行,就出错了。如下:
java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3208)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3518)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2353)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2269)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1428)
at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1401)
at com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:204)
at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1212)
at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:202)
at cn.com.dwsoft.collector.impl.db.DBReader.execute(DBReader.java:139)
at cn.com.dwsoft.collector.CollectReader.run(CollectReader.java:69)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqli.E(IfxSqli.java:3523)
... 10 more
请多帮帮。。。。
收起