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

From Tom Lane
Subject Re: java.sql.SQLException: ERROR: canceling query due
Date
Msg-id 12191.1124405415@sss.pgh.pa.us
Whole thread Raw
In response to Re: java.sql.SQLException: ERROR: canceling query due  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-jdbc
"Kevin Grittner" <Kevin.Grittner@wicourts.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

pgsql-jdbc by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: java.sql.SQLException: ERROR: canceling query due
Next
From: Kris Jurka
Date:
Subject: Re: Memory leak in 8.0 JDBC driver?