Need help with org.postgresql.util.PSQLException: An I/O error occured while sending to the backend.

Hi,

I´ve written a small JDBC-application.
I´m quering a large table in a postgreSQL database (version 8.08 and I´m
using the postgresql-8.1-407.jdbc3 driver). I need to update a lot of
the rows in the table and I try to do this 'on-the-fly' - that is, I use
one statement to select the rows and while looping over the ResultSet  I
use another one to update the row if needed.

The updates are executing very slowly, which is due to the fact that the
database server is slow.
I keep getting this exception:

org.postgresql.util.PSQLException: An I/O error occured while sending to
the backend.
    at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:214)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
    at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:347)
    at
se.puzzled.ip.InsertIPCountryToDatabase.updateCountryCodesInUclickUsingVector(InsertIPCountryToDatabase.java:239)
    at se.puzzled.updater.CountryDriver.main(CountryDriver.java:30)
Caused by: java.net.SocketException: Connection reset
    at java.net.SocketInputStream.read(Unknown Source)
    at java.io.BufferedInputStream.fill(Unknown Source)
    at java.io.BufferedInputStream.read(Unknown Source)
    at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:256)
    at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1163)
    at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
    ... 5 more

Some updates execute correctly, but then the application crashes with
the exception.

I´ve seen other posts concerning this exception, but what I´d like is a
way to prohibit the
exception within my Java code - haven´t found any such solution in the
posts that I´ve read.

Any help would be very much appreciated!