Re: conflict txns in serialization isolation

Поиск
Список
Период
Сортировка
Искать
От
Yi LIN
Тема
Re: conflict txns in serialization isolation
Дата
Msg-id
Pine.GSO.4.44.0407261347370.29092-100000@willy
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Tom Lane
Дата:
От: Ian Pilcher
Дата:
FAQ