BUG #1251: setTransactionIsolation does not seem to work

The following bug has been logged online:

Bug reference: 1251
Logged by: Fernando Bellas

Email address: fbellas(at)udc(dot)es

PostgreSQL version: 7.4.3

Operating system: Red Hat 7.1

Description: setTransactionIsolation does not seem to work

Details:

Hi,

First of all, the version I am using of PostgreSQL is 7.4.5, and *not* 7.4.3
(I have set 7.4.3 in the form, since it does not allow to choose 7.4.5).

I have tested several JDBC drivers (pg74.213.jdbc3.jar, pg74.215.jdbc3.jar,
pg74.213.jdbc2.jar and pg74.213.jdbc2ee.jar), and
connection.setTransactionIsolation does not change the transaction isolation
level (maybe the problem is with the database and not with the JDBC driver).

The following code prints "2" (TRANSACTION_READ_COMMITED) as the value of
the transaction isolation levels.

connection.setAutoCommit(false);
int oldTransactionIsolation =
connection.getTransactionIsolation();
System.out.println("oldTransactionIsolation = " +
oldTransactionIsolation);
connection.setTransactionIsolation(
Connection.TRANSACTION_SERIALIZABLE);
System.out.println("newTransactionIsolation = " +
connection.getTransactionIsolation());

Thanks in advance!
Fernando.