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


Wed, 31 Jul 2002 15:47:28 -0700
Yuva Chandolu <ychandolu@ebates.com>
IO error - please help