I use the following code to query a column that contains a long data
type in an Oracle DB.

*******

 String SQL = "select .....";
 stmt.execute(SQL);
 rs = stmt.getResultSet();

 while (rs.next()) {
     String projectID = rs.getString("PROJECT_ID");
     Grant  g = (Grant) grantsIndexedById.get(projectID);
     if (g != null ) {
//       g.addResearchData(rs);
        g.setResearchTitle(rs.getString("DESCR254_MIXED"));

        InputStream in = rs.getAsciiStream("DESCRLONG");
        StringBuffer sb = new StringBuffer();
        int b;
        while ((b=(int)in.read())!=-1){
            sb.append((char)b);
        }

        g.setResearchSummary(sb.toString());
        g.setResearchField(rs.getString("XLATLONGNAME"));

     }

< ... more code here ...>

public void addResearchData(ResultSet rs) throws SQLException,
IOException {

   researchField  = rs.getString("XLATLONGNAME");
   researchTitle = "RESEARCH TITLE GOES HERE";

   // THE FOLLOWING LINE IS WHERE THE EXCEPTION GETS THROWN !
   InputStream in = rs.getAsciiStream("DESCRLONG");
   StringBuffer sb = new StringBuffer();
   int b;
   while ((b=(int)in.read())!=-1){
       sb.append((char)b);
   }
   researchSummary = sb.toString();
}

**************

The code works fine. But when I comment out everything inside the
first "if" statement and un-comment out the line
"g.addResearchData(rs)";

I receive the SQLException "Stream has already been closed" on the
line:

 InputStream in = rs.getAsciiStream("DESCRLONG");

In the addResearchData() method.

In other words when I move the code into a separate method I receive
the SQLException. Has anyone seen this before? Can anyone offer an
explanation?

Thanks in advance,
Matt