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?*
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 |