From: | Yuva Chandolu <ychandolu(at)ebates(dot)com> |
---|---|
To: | "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | IO error - please help |
Date: | 2002-07-31 22:19:41 |
Message-ID: | A0F24737FCB34F489EC955D143BDD8510173E0FD@exchange-sf1.corp.ebates.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
We had seen the following exception when we tried for a heavy query(around
10000 to 20000 in result is possible)
An I/O error occured while reading from backend - Exception:
java.net.SocketException: socket closed: Bad file number
Stack Trace:
java.net.SocketException: socket closed: Bad file number
at java.net.SocketInputStream.socketRead(Native Method)
at java.net.SocketInputStream.read(SocketInputStream.java:90)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:186)
at java.io.BufferedInputStream.read(BufferedInputStream.java:204)
at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:141)
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:68)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
at
org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement
.java:99)
at
com.ebates.payments.PaymentsDatabaseHandler.getPendingUserRebates(Pay
mentsDatabaseHandler.java:751)
Any idea what level it is happenning? database? or the jdbc driver? We do
NOT have this problem when we were on Oracle.
Thanks
Yuva
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Stead | 2002-07-31 23:31:26 | Re: Bad Timestamp Format Error |
Previous Message | bvol | 2002-07-31 21:37:08 | dbvisualizer and jdbc driver in postgres7.2 |