Re: java.sql.SQLException: ERROR: canceling query due - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: java.sql.SQLException: ERROR: canceling query due
Date
Msg-id Pine.BSO.4.62.0508191239350.7406@leary.csoft.net
Whole thread Raw
In response to Re: java.sql.SQLException: ERROR: canceling query due  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-jdbc

On Fri, 19 Aug 2005, Kevin Grittner wrote:

> So you would add a variable to the statement class to save to when the
> set method is invoked, return this value from the get method, and when
> an execute method is invoked, if the value is non-zero, you would
> bracket what is currently sent to the server with a SET to the non-zero
> value and back to zero (in a finally clause)?
>

Right.  Setting it back to zero doesn't even need to happen in the error
path because an error requires ROLLBACK and that will reset the
statement_timeout setting as well.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: COPY support survey
Next
From: Kris Jurka
Date:
Subject: Re: COPY support survey