Re: Another exception (Transaction level)

Hi Paul,

Paul Thomas writes:
 > > sorry if I flood you with lots of messages, but I am quite new to
 > > Postgresql and I find a lot of questions not answered in the manual.
 > > I get randomly (probably when I have concurrent r/w access) the error
 > > message
 > > java.sql.SQLException: ERROR:  SET TRANSACTION ISOLATION LEVEL must be
 > > called before any query
 > > when I do a commit(). But I had set this level at the very beginning with
 > > dbConn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

 > Do you do this before or after dbConn.setAutoCommit(false).

Befor. The steps I do are

Connection dbConn;
dbConn = java.sql.DriverManager.getConnection(...);
dbConn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
dbConn.setAutoCommit(false);

and then I use this instance of dbConn for querys and updates (which
may occur concurrently at the same time).

 > > BTW, I tried to use TRANSACTION_READ_UNCOMMITTED (which is described
 > > in the manual)
 > I don't believe that read uncommitted is supported by PostgreSQL.

Finally, I found out the same when searching the net. But, why the
user's manual (9.2. "Transaction Isolation") states something
different? I guess it should be corrected in the manual.

Ciao

Ole