The following bug has been logged online:
Bug reference: 4123
Logged by: Amit Mujawar
Email address: amit(dot)mujawar(at)gmail(dot)com
PostgreSQL version: 8.1
Operating system: Windows XP
Description: Statement.setQueryTimeout does not work with Postgres
Java Driver
Details:
I am using PostgreSQL through JDBC
PostgreSQL 8.1, Driver - org.postgresql.Driver 8.1-408.jdbc3
When I set Statement.setQueryTimeout, the timeout value does not show any
effect on actual timeout...The query blocks for a specific time always [may
be configured by another global variable - statement_timeout? not sure]
I suspect there is a problem with JDBC driver implementation for
setQueryTimeout API.