java - 关闭结果集的游标？

Question

来自this oracle java教程:

The following statement specifies that the cursor of the ResultSet object generated from the getPrice query is closed when the commit method is called. Note that if your DBMs does not support ResultSet.CLOSE_CURSORS_AT_COMMIT, then this constant is ignored:

getPrice = con.prepareStatement(query, ResultSet.CLOSE_CURSORS_AT_COMMIT);

这是否意味着ResultSet.CLOSE_CURSORS_AT_COMMIT关闭了ResultSet？从名字上看，它只是关闭了ResultSet的游标。如果是这样的话，那有什么用呢？PS:我知道在 con.commit() 之后发生的任何事情都会结束。但实际上关闭了什么？光标？光标是什么意思？提前致谢。

Answer 1

这就是 the javadoc说:

The constant indicating that open ResultSet objects with this holdability will be closed when the current transaction is commited.

所以是的，结果集本身将被关闭。