Lists: | pgsql-jdbc |
---|
From: | Håkan Jacobsson <hakan(dot)jacobsson(at)relevanttraffic(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Need help with org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. |
Date: | 2006-11-09 13:12:01 |
Message-ID: | 45532921.7030303@relevanttraffic.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
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!
From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Håkan Jacobsson <hakan(dot)jacobsson(at)relevanttraffic(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Need help with org.postgresql.util.PSQLException: An I/O error occured while sending to the backend. |
Date: | 2006-11-09 13:44:34 |
Message-ID: | 9BBDE237-0E8C-4303-AFB2-2DA39664DDFC@fastcrypt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-jdbc |
The problem is that the connection is being dropped, or lost, or
broken. Is there a firewall involved ?
Dave
On 9-Nov-06, at 8:12 AM, Håkan Jacobsson wrote:
> 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.updateCountryCodesInUclickUsin
> gVector(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!
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>