| From: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Help with query timeout |
| Date: | 2012-10-06 19:41:11 |
| Message-ID: | BLU0-SMTP393B91833C4441664F673E8CF8A0@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
Thanks,
Edson Richter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-10-06 19:43:27 | Re: 'full_page_writes=off' , VACUUM and crashing streaming slaves... |
| Previous Message | Sean Chittenden | 2012-10-06 17:32:00 | 'full_page_writes=off' , VACUUM and crashing streaming slaves... |