JDBC and setting statement_timeout

From: Jason Long <mailing(dot)list(at)supernovasoftware(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: JDBC and setting statement_timeout
Date: 2008-11-04 00:41:46
Message-ID: 490F9A4A.6070208@supernovasoftware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In order to keep my application from freezing up when a query pegs my
CPU I set statement_timeout=120000, but I read in the manual

"Setting statement_timeout in postgresql.conf is not recommended because
it affects all sessions."

I am used JDBC exclusively for the applicatoin and I read here

http://www.nabble.com/Implementing-setQueryTimeout()-ts15537669.html
<http://www.nabble.com/Implementing-setQueryTimeout%28%29-ts15537669.html>

that setTimeout is not implemented in the JDBC driver for PostgreSQL.

I would like for nearly all of my queries to throw and error if they do
not complete in a certain time and if I know if might take more I would
like to set this explicitly for that query.

*Would someone please comment on the status of setQueryTimeout in the
JDBC driver?
Is there any workaround if this is still not implemented?*

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2008-11-04 00:46:37 Re: JDBC and setting statement_timeout
Previous Message Kevin Neufeld 2008-11-04 00:29:22 many tables vs large tables