Re: Help with query timeout

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Help with query timeout
Дата
Msg-id 20121007054651.GA5071@tux
обсуждение исходный текст
Ответ на Help with query timeout  (Edson Richter <edsonrichter@hotmail.com>)
Ответы Re: Help with query timeout  (Edson Richter <edsonrichter@hotmail.com>)
Список pgsql-general
Edson Richter <edsonrichter@hotmail.com> wrote:

> Dear friends,
>
> I'm using Java 1.6 with Jdbc 4 driver with PostgreSQL 9.1.5 on Windows
> 64 and Linux 64.
> Trying to use setQueryTimeout(int), I get the following stack trace:
> Internal Exception: org.postgresql.util.PSQLException: Method
> org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) not yet
> implemented.
> (free translation of the equivalent Portuguese message).
>
> My question is: if setQueryTimeout is not implemented, how can I set a
> query timeout parameter (per query or per session) using PostgreSQL? Is
> there any "set ..." or connection parameter I can use?

Yeah:

statement_timeout



Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


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

Предыдущее
От: Edson Richter
Дата:
Сообщение: Help with query timeout
Следующее
От: r d
Дата:
Сообщение: Question about PARTIAL DATE type/s