欢迎您访问 最编程 本站为您分享编程语言代码,编程技术文章!
您现在的位置是: 首页

错误消息ORA-00933:SQL命令未正确结束-问答-阿里云开发者社区-阿里云

最编程 2024-01-10 16:04:46
...

我对此方法有疑问:

public void insertIntoQueue(DTOQueue dtoQueue) { DbConnection dbConnection = new DbConnection(); Connection conn; try { conn = dbConnection.coneccion(); String sql = " INSERT INTO PURE_ENC_QUEUE (queueId,queueName) values(?,?);";

    //creating PreparedStatement object to execute query
    PreparedStatement preStatement = conn.prepareStatement(sql);
    preStatement.setString(1, dtoQueue.getQueueId());
    preStatement.setString(2, dtoQueue.getQueueName());
    int result = preStatement.executeUpdate();

    DbConnection.closeConnection(conn);

    if(result > 0) {
        System.out.println("Insertado");
    } else {
        System.out.println("No insertado");
    }

} catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
} catch (InstantiationException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
} catch (IllegalAccessException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
} catch (ClassNotFoundException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
}
System.out.println("done");

} 当我运行它时,抛出异常

java.sql.SQLException:ORA-00933:SQL命令未正确结束

对这个问题有任何想法吗?谢谢!

问题来源于stack overflow