Обсуждение: Timeouts on big queries with JDBC?

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
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.

 

Ian S. Nelson wrote:
> 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.

Unless you're seeing other errors (check the server logs too) before the
quoted exception, this doesn't look like a timeout problem. Rather, it
looks like you're trying to use a resultset after the connection that
created it was closed. The JDBC spec doesn't let you do this -- check
your application code.

-O