Re: java.sql.SQLException: ERROR: canceling query due

From: Kris Jurka <books(at)ejurka(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: java.sql.SQLException: ERROR: canceling query due
Date: 2005-08-19 17:41:47
Message-ID: Pine.BSO.4.62.0508191239350.7406@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-08-19 17:52:46 Re: COPY support survey
Previous Message Dave Cramer 2005-08-19 17:34:58 Re: COPY support survey