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