Re: [GENERAL] JDBC and setting statement_timeout

2008-11-04 Thread Jason Long
Kris Jurka wrote: On Mon, 3 Nov 2008, Jason Long wrote: *Would someone please comment on the status of setQueryTimeout in the JDBC driver? Is there any workaround if this is still not implemented?* setQueryTimeout is not implemented, the workaround is to manually issue SET

[GENERAL] JDBC and setting statement_timeout

2008-11-03 Thread Jason Long
In order to keep my application from freezing up when a query pegs my CPU I set statement_timeout=12, 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

Re: [GENERAL] JDBC and setting statement_timeout

2008-11-03 Thread Kris Jurka
On Mon, 3 Nov 2008, Jason Long wrote: *Would someone please comment on the status of setQueryTimeout in the JDBC driver? Is there any workaround if this is still not implemented?* setQueryTimeout is not implemented, the workaround is to manually issue SET statement_timeout = xxx calls