David Gagnon wrote:
> I just wanted to be sure since it's not clear in the
> javadoc that closing a uncomitted resultSet is the samething as issuing
> a rollback prior to closing the ResultSet.
Closing ResultSet objects has no effect on transactions. Closing
Connection objects does.
The PostgreSQL driver implements this behaviour: if autocommit is false,
changes in the current transaction are committed only when you call
Connection.commit() or Connection.setAutoCommit(). So closing the
connection does cause a rollback, since that connection is then dead and
can't be committed.
In response to
pgsql-jdbc by date
|Next:||From: Oliver Jowett||Date: 2005-04-20 23:24:48|
|Subject: Re: JDBC locking on processResults|
|Previous:||From: Oliver Jowett||Date: 2005-04-20 23:15:34|
|Subject: Re: implementing asynchronous notifications|