sql运行出现java.sql.SQLException: A syntax error has occurred
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
请多帮帮。。。。
在程序里会把这个语句打印出来，这它复制到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
请多帮帮。。。。
25同行回答
回复 14# liaosnet
看了数据库连接字符串,客户端与项目中都是这个：jdbc:informix-sqli://136.74.100.10:9007/smpdb:informixserver=smp_online_net;DB_LOCALE=en_us.819;CLIENT_LOCALE=en_us.57372;NEWCODESET=GBK,8859-1,819 里面没有ifx_allow_newline ??
现在客户端执行select first 10 callingnumber from smp.u_uvc_logonuser;出了一个问题：
16:55:19 [SELECT - 0 row(s), 0.000 secs] [Error Code: -243, SQL State: IX000] Could not position within a table (smp.u_uvc_logonuser).
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
是什么意思啊？
informix不会的东西太多了，望多指教。。收起
看了数据库连接字符串,客户端与项目中都是这个：jdbc:informix-sqli://136.74.100.10:9007/smpdb:informixserver=smp_online_net;DB_LOCALE=en_us.819;CLIENT_LOCALE=en_us.57372;NEWCODESET=GBK,8859-1,819 里面没有ifx_allow_newline ??
现在客户端执行select first 10 callingnumber from smp.u_uvc_logonuser;出了一个问题：
16:55:19 [SELECT - 0 row(s), 0.000 secs] [Error Code: -243, SQL State: IX000] Could not position within a table (smp.u_uvc_logonuser).
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
是什么意思啊？
informix不会的东西太多了，望多指教。。收起
浏览1437
回复 liaosnet ifx_allow_newline是什么意思啊？允许输入的SQL语句换行吗？ 请解释一下吧。 ...herry118423 发表于 2011-5-25 16:20
只是怀疑。。。你先确认前面提到的问题吧。。ifx_allow_newline是允许字段内换行。。若是没支持，可...浏览1369
浏览1363
浏览1831
浏览1815
浏览1817