[HACKERS] PostgreSQL JDBC driver Connection.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE)failures

2003-08-14 Thread Dave Tenny
I'm using 7.3.3 of the server, and pg73b1jdbc2.jar for the JDBC driver. Various permutations of calls to the setTransactionIsolation all fail to yield a driver state that will tell me that it is set up for serializable transactions. Help!? I googled, I grepped. I find mention of problems with re

[HACKERS] PostgreSQL JDBC driver Connection.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE)failures

2003-08-05 Thread Dave Tenny
I'm using 7.3.3 of the server, and pg73b1jdbc2.jar for the JDBC driver. Various permutations of calls to the setTransactionIsolation all fail to yield a driver state that will tell me that it is set up for serializable transactions. Help!? I googled, I grepped. I find mention of problems with

Re: [HACKERS] [JDBC] Out of memory error on huge resultset

2002-10-16 Thread Dave Tenny
> > > > To work > > > > around this you can use explicit cursors (see the DECLARE CURSOR, > > > > FETCH, and MOVE sql commands for postgres). I'm unable to get this to work using the default distribution JDBC driver. (7.2). Here's a code snippet conn.setAutoCommit(false) ; stmt.exe