Re: timeout implementation issues

On Tue, 2 Apr 2002, Bruce Momjian wrote:

>     BEGIN WORK;
>     query;
>     SET statement_timeout = 4;
>     query;
>     SET statement_timeout = 0;
>     query;
>     COMMIT;
>     SET statement_timeout = 0;
> 
> Basically, it does the reset twice, once assuming the transaction
> doesn't abort, and another assuming it does abort.  Is this something
> that the JDBC and ODBC drivers can do automatically?

I can't speak for ODBC. Seems like in JDBC, Connection::commit() would
call code clearing the timeout, and Statement::executeQuery() and
executeUpdate() would do the same.

j