Re: Help with query timeout - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Help with query timeout
Date
Msg-id 20121007054651.GA5071@tux
Whole thread Raw
In response to Help with query timeout  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Help with query timeout
List 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 by date:

Previous
From: Edson Richter
Date:
Subject: Help with query timeout
Next
From: r d
Date:
Subject: Question about PARTIAL DATE type/s