Hi all,
We have an application based on DB2
database, We are testing this same application on PostgreSQL database.
By default we are in autocommit on mode.
On DB2 (and Oracle), the query SELECT
FOR UPDATE locks the row until the resultset is closed. On PostgreSQL database
(all versions) this same query never locks (because we are in autocommit
on mode). But this is a bad implementation of JDBC specification : "If
a connection is in auto-commit mode, then all its SQL statements will be
executed and committed as individual transactions.[...] The commit occurs
when the statement completes or the next execute occurs, whichever comes
first. In the case of statements returning a ResultSet object, the statement
completes when the last row of the ResultSet object has been retrieved
or the ResultSet object has been closed."
Is it possible to lock row in autocommit
on mode on PostgreSQL database ?