java.sql.SQLException : ORA-00933: SQL command not properly ended when using getGeneratedKeys 异常

Question

当我使用以下查询时它有效。

query = "INSERT INTO MLRL1_PSR_MASTER (PROJECT_ID,FROM_DATE,TO_DATE,TEMPLATE_ID,TEMPLATE_TYPE,UPLOADED_BY,PSR_SLABID) " +
        " select '"+projectId+"' , FROM_DATE , TO_DATE,'"+templateId+"','"+tempType+"','"+user.getUserID()+"', "+slabId+
        " from MLRL1_PSR_SLABS where SLAB_ID="+slabId+" ";

stmt = connection.prepareStatement(query, new String[] { "ID" });
stmt.executeUpdate();
stmt = connection.prepareStatement(query);

但是如果我对 getGeneratedKeys() 使用相同的查询，例如:

stmt = connection.prepareStatement(query, new String[] { "ID" });
stmt.executeUpdate();
ResultSet rs = stmt.getGeneratedKeys();

while (rs.next()) {
    masterId = rs.getInt(1);
}

我得到一个错误

ORA-00933: SQL command not properly ended

stmt 为 java.sql.PreparedStatement，代码合规性为 1.6，JRE 为 1.7.67 Oracle 驱动程序为 odbc6，数据库为 Oracle 数据库 11g 企业版 11.2。 0.1.0

Answer 1

我认为语法不正确。您可能需要在查询中添加“VALUES”。插入查询应类似于 - INSERT INTO TABLE_NAME VALUES ();