当使用JDBC为Oracle 10g(10.2.0.1.0)创建以下准备语句时，我得到ORA-00933:
conn.prepareStatement("INSERT INTO fx_tv_date (id, mp, doc_id, effective, actual, stale, val) VALUES (?, ?, ?, ?, ?, ?, ?)");
该行抛出了以下异常…
java.sql.SQLException: ORA-00933: SQL command not properly ended
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801)
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841)
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1274)
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:205)
在MySQL &MS SQL Server所以我猜这是与Oracle的语法差异，但在网上搜索我似乎看不到原因。为清楚起见，下面是准备好的语句:
INSERT INTO fx_tv_date (id, mp, doc_id, effective, actual, stale, val) VALUES (?, ?, ?, ?, ?, ?, ?)
谢谢!
执行DML时使用的方法是executeupdate，而不是executeQuery。