JDBC postgres query with a timeout

Question

Unfortunately setTimeout is not implemented for JDBC/postgres. Is there some way I can simulate or workaround this? Functionally I want to execute the query and the then break if it takes longer than N seconds

Answer 1

One way might be to try running the query in a Timer class. Throw an exception if the Timer ends without a value returned.

Hibernate and JDO supply such a construct. Maybe they'd be good alternatives for you.

Answer 2

The "statement_timeout" looks like what you want.

SET statement_timeout TO 1000; -- for a second
<your_query_here>;
RESET statement_timeout; -- reset

Answer 3

What if you were to use c3p0 for your dataSource? It has lots of configurable options, and for cranky databases and networks, for example, acquireRetryAttempts, acquireRetryDelay, and breakAfterAcquireFailure.