From: | "Ian S(dot) Nelson" <ian(at)stillsecure(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Timeouts on big queries with JDBC? |
Date: | 2004-05-14 16:31:48 |
Message-ID: | 40A4F474.1030608@stillsecure.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm doing some huge queries with a cursor and JDBC on Postgresql
7.4.2 It has been working pretty well so far but I've ramped my data
set up a bit and now I get these exceptions when iterating through the
results set:
org.postgresql.util.PSQLException: Connection is closed. Operation is
not permitted.
Is this a time out problem? Something else? There is about 10million
rows in the table I'm querying.
thanks,
Ian
--
. . .
*Ian S. Nelson
Senior Software Engineer*
*StillSecure*
303-381-3813 Direct
303-381-3881 Fax
www.stillsecure.com <http://www.stillsecure.com>
/Reducing your risk has never been this easy./
. . .
/The information transmitted is intended only for the person
to which it is addressed and may contain confidential material.
Review or other use of this information by persons other than
the intended recipient is prohibited. If you've received
this in error, please contact the sender and delete
from any computer. /
From | Date | Subject | |
---|---|---|---|
Next Message | Jeffrey W. Baker | 2004-05-14 16:38:07 | Re: pg_xlog becomes extremely large during CREATE INDEX |
Previous Message | Theo Dickinson | 2004-05-14 16:02:08 | ROW LEVEL UPDATE TRIGGER column detect problem |