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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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