Re: java.sql.SQLException: ERROR: canceling query due

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: java.sql.SQLException: ERROR: canceling query due
Дата
Msg-id Pine.BSO.4.62.0508191239350.7406@leary.csoft.net
обсуждение исходный текст
Ответ на Re: java.sql.SQLException: ERROR: canceling query due  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-jdbc

On Fri, 19 Aug 2005, Kevin Grittner wrote:

> So you would add a variable to the statement class to save to when the
> set method is invoked, return this value from the get method, and when
> an execute method is invoked, if the value is non-zero, you would
> bracket what is currently sent to the server with a SET to the non-zero
> value and back to zero (in a finally clause)?
>

Right.  Setting it back to zero doesn't even need to happen in the error
path because an error requires ROLLBACK and that will reset the
statement_timeout setting as well.

Kris Jurka

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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: COPY support survey
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: COPY support survey