Name: rmT116609 Date: 03/02/2004
A DESCRIPTION OF THE PROBLEM :
The java.sql.Connection.setAutoCommit Javadoc says, "the statement completes when the last row of the ResultSet object has been retrieved or the ResultSet object has been closed." This is no longer true with JDBC 2.0. Since one can scroll the result set backwards and forwards, the implementation of the result set can't commit the transaction simply because the last row has been read. The statement should now read, "the statement completes when the ResultSet object has been closed."
http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#setAutoCommit(boolean)
(Incident Review ID: 193348)
======================================================================
A DESCRIPTION OF THE PROBLEM :
The java.sql.Connection.setAutoCommit Javadoc says, "the statement completes when the last row of the ResultSet object has been retrieved or the ResultSet object has been closed." This is no longer true with JDBC 2.0. Since one can scroll the result set backwards and forwards, the implementation of the result set can't commit the transaction simply because the last row has been read. The statement should now read, "the statement completes when the ResultSet object has been closed."
http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Connection.html#setAutoCommit(boolean)
(Incident Review ID: 193348)
======================================================================