Re: JDBC behaviour

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: JDBC behaviour
Дата
Msg-id CAMsr+YF6nj0Qh+A0J3hJrQD1ofwq_=k_tXUewb0EQO_0uj7Azg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: JDBC behaviour  (John R Pierce <pierce@hogranch.com>)
Ответы Re: JDBC behaviour  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-jdbc
On 20 February 2016 at 19:05, John R Pierce <pierce@hogranch.com> wrote:
 

to me this seems to break the rules of transaction semantics, but it matches the behavior with autocommit=on  ...


... which doesn't matter, because if you wanted that you'd just set autocommit=on.

I think all this discussion of autocommit is a pointless side-track. Reading between the lines, the real complaint appears to be that we abort the xact if a statement ERRORs, and by default other DBMS vendors don't. OP wants something like psqlODBC's "statement" error-rollback mode where savepoints are done automatically before each statement.

Of course they're contending that PgJDBC's behaviour is wrong because it doesn't do exactly what they expect, with no reference to the specs and standards concerned, which doesn't help. They're also using a bunch of incomplete pseudocode and vague references to make the argument, which means it's all really rather hard to follow. But I'm pretty sure the above is what they actually mean, like in https://github.com/pgjdbc/pgjdbc/issues/423 .

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: JDBC behaviour
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: JDBC behaviour