Oracle error - "Stream has already been closed"

Friends,

I got your mail id from the mailing list and I understood that you have
experienced the below error..

I am getting this error from a table that has a LONG RAW column.  In the
select statement I have put 'LONG RAW' Column first and in the rs.next(),
I am retrieving the LONG RAW column first. But even then I am getting this
error.  Do u have any idea?


Below is a sample code I am using...


selProcess = conn.prepareStatement  ("select data(this is Long raw column),
intername, transid, transorder, errorcount, emailsent from max_interdata
order by transid, transorder, rowstamp");

ResultSet rsetMax = selProcess.executeQuery();

                try
                {
                    while (rsetMax.next())
                    {

                        //08/15/02, JB -- using getBinaryStream() instead
of getBytes() to
                        //work around Oracle driver bug
                        InputStream inputStream = null;
                        try
                        {
                          inputStream = rsetMax.getBinaryStream(1);
                          data = readBinaryData(inputStream);
// method to convert the inputsream to my object
                          interfaceName = rsetMax.getString(2);
                          transID = rsetMax.getLong(3);
                          transOrder = rsetMax.getLong(4);
                          errorCount = rsetMax.getInt(5);
                          emailSent =  rsetMax.getString(6);
                        }





000.         000: String.java.lang.String:Stack trace:
java.sql.SQLException: Stream has already been closed
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:222)
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:285)
      at
oracle.jdbc.dbaccess.DBDataSetImpl.getStreamItem(DBDataSetImpl.java:1145)
      at
oracle.jdbc.driver.OracleStatement.getBinaryStreamValue(OracleStatement.java:4616)
      at
oracle.jdbc.driver.OracleResultSetImpl.getBinaryStream(OracleResultSetImpl.java:398)
      at
psdi.iface.interdata.MaxInterDataBatch.processInterData(MaxInterDataBatch.java:150)
      at
psdi.iface.mic.MicService$PollMaxInterdataBatch.run(MicService.java:1723)
      at java.lang.Thread.run(Thread.java:484)


Thanks & Regards,

Seenivasan Chandrasekararaja.