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