Attached is a patch that fixes ConnectionTest.testTransactionIsolation() in the JDBC driver's test suite. This reduces the number of failures of the test suite from 7 to 6. The patch fixes the test case itself, rather than the driver.
Attached is a patch that fixes
ConnectionTest.testTransactionIsolation() in the JDBC driver's
test suite. This reduces the number of failures of the test
suite from 7 to 6. The patch fixes the test case itself, rather
than the driver.

In addition to the change described in my posting below, I fixed
the part of the test with autocommit enabled. The author of the
test assumed that setting the transaction isolation level would
have no effect, but in fact it does. Perhaps the test case
worked with pre-7.1 behaviour, when the JDBC driver set the
isolation level in every transaction, instead of using "set
session characteristics". Anyway, now it works with a backend
built from current CVS and the behaviour is JDBC compliant.

I also extended the test case by changing the isolation level
before beginning a transaction and verifying it inside the
transaction.

Regards,
Ren? Pijlman

thkoch2001/libpostgresql-jdbc-java,AlexElin/pgjdbc,jkutner/pgjdbc,jorsol/pgjdbc,davecramer/pgjdbc,lonnyj/pgjdbc,rjmac/pgjdbc,thkoch2001/libpostgresql-jdbc-java,ekoontz/pgjdbc,sehrope/pgjdbc,golovnin/pgjdbc,thkoch2001/libpostgresql-jdbc-java,rjmac/pgjdbc,jamesthomp/pgjdbc,tivv/pgjdbc,amozhenin/pgjdbc,jamesthomp/pgjdbc,ekoontz/pgjdbc,zapov/pgjdbc,jkutner/pgjdbc,davecramer/pgjdbc,phillipross/pgjdbc,phillipross/pgjdbc,schlosna/pgjdbc,davecramer/pgjdbc,Gordiychuk/pgjdbc,lonnyj/pgjdbc,sehrope/pgjdbc,panchenko/pgjdbc,schlosna/pgjdbc,zemian/pgjdbc,AlexElin/pgjdbc,zemian/pgjdbc,underyx/pgjdbc,panchenko/pgjdbc,Gordiychuk/pgjdbc,Gordiychuk/pgjdbc,golovnin/pgjdbc,underyx/pgjdbc,jorsol/pgjdbc,pgjdbc/pgjdbc,pgjdbc/pgjdbc,alexismeneses/pgjdbc,sehrope/pgjdbc,tivv/pgjdbc,davecramer/pgjdbc,marschall/pgjdbc,bocap/pgjdbc,marschall/pgjdbc,panchenko/pgjdbc,AlexElin/pgjdbc,jkutner/pgjdbc,alexismeneses/pgjdbc,jorsol/pgjdbc,amozhenin/pgjdbc,phillipross/pgjdbc,jorsol/pgjdbc,rjmac/pgjdbc,underyx/pgjdbc,zapov/pgjdbc,whitingjr/pgjdbc,lordnelson/pgjdbc,bocap/pgjdbc,golovnin/pgjdbc,pgjdbc/pgjdbc,zemian/pgjdbc,bocap/pgjdbc,whitingjr/pgjdbc,pgjdbc/pgjdbc,zapov/pgjdbc,whitingjr/pgjdbc,jamesthomp/pgjdbc,lordnelson/pgjdbc,amozhenin/pgjdbc,marschall/pgjdbc,lordnelson/pgjdbc,sehrope/pgjdbc,marschall/pgjdbc