Re: Implementing setQueryTimeout()

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: Implementing setQueryTimeout()
Дата
Msg-id 47BA491E.9090603@opencloud.com
обсуждение исходный текст
Ответ на Re: Implementing setQueryTimeout()  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Implementing setQueryTimeout() - round 2  (Oliver Jowett <oliver@opencloud.com>)
Список pgsql-jdbc
Tom Lane wrote:
> Oliver Jowett <oliver@opencloud.com> writes:
>> Tom Lane wrote:
>>> I think it's a serious, serious conceptual error to tie network timeouts
>>> to query timeouts.
>
>> Why? I don't understand this argument.
>
> Because the failure mechanisms that you're worried about are completely
> different in the two cases, and don't necessarily have similar timeout
> requirements (to say nothing of the appropriate recovery actions).

Which is fair enough .. but I have a single JDBC method to work with
here. I could implement something driver-specific but it seems a little
silly to have timeout behaviour in the driver but have the standard
method unimplemented.

Note that you could implement different recovery behaviour by looking at
the SQLState of the thrown exception easily enough.

-O


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Implementing setQueryTimeout()
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: Implementing setQueryTimeout() - round 2