Re: conflict txns in serialization isolation
От
Yi LIN
Тема
Re: conflict txns in serialization isolation
Дата
Msg-id
Pine.GSO.4.44.0407261347370.29092-100000@willy
Ответ на
Re: conflict txns in serialization isolation (Kris Jurka)
Список
Дерево обсуждения
conflict txns in serialization isolation Yi LIN <ylin30@cs.mcgill.ca>
Re: conflict txns in serialization isolation Tom Lane <tgl@sss.pgh.pa.us>
Re: conflict txns in serialization isolation Yi LIN <ylin30@cs.mcgill.ca>
Re: conflict txns in serialization isolation Tom Lane <tgl@sss.pgh.pa.us>
Re: conflict txns in serialization isolation Yi LIN <ylin30@cs.mcgill.ca>
Re: conflict txns in serialization isolation Kris Jurka <books@ejurka.com>
Re: conflict txns in serialization isolation Yi LIN <ylin30@cs.mcgill.ca>
Hi Kris: > > db = DriverManager.getConnection(url, username, password); > > db.setAutoCommit(false); > > db.setTransactionIsolation(java.sql.Connection.TRANSACTION_SERIALIZABLE); > > > > I think you want to set the transaction isolation before starting the > transaction by turning off autocommit. Later versions of the driver make > this work correctly or throw an error on this situation, but I recall you > were using an old version. So try reordering the last two lines. Now it works correctly as psql. Thanks a lot! Yi Lin
В списке pgsql-jdbc по дате отправления