Skip site navigation (1) Skip section navigation (2)

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: oliver(at)opencloud(dot)com, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: java.sql.SQLException: ERROR: canceling query due
Date: 2005-08-18 22:50:15
Message-ID: 12191.1124405415@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-jdbc
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> Thanks much for the clarification.  The statement_timeout setting is
> commented out, with a note that it defaults to zero and that this
> means it is disabled. 

The fact that it's commented out doesn't mean that it's not been set
from elsewhere, such as a per-user default, or even a prior state of
the config file.  It'd be more trustworthy to connect to the server
as the same user your JDBC client runs as, and do "SHOW
statement_timeout".

			regards, tom lane

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2005-08-19 04:33:06
Subject: Re: Memory leak in 8.0 JDBC driver?
Previous:From: Kevin GrittnerDate: 2005-08-18 22:40:32
Subject: Re: java.sql.SQLException: ERROR: canceling query due

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group