JDBC issue with Oracle LONG datatype

[Ravi Madhavan]

Hi there I am trying to do an update to a table which contains a column of LONG datatype in a ORacle Db.

The problem I have is that I keep experiencing the error :

java.sql.SQLException: Stream has already been closed

The table contains 3 columns I am reading off (the other two being integer and varchar2).

   
 String sql = "SELECT id, xmlColumn, summaryColumn FROM dummy_table" ;
  PreparedStatement pstmt = conn.prepareStatement(sql);
  
      ResultSet rset = pstmt.executeQuery();
 
  String updateSQL = "UPDATE dummy_table SET xmlColumn=?, summaryColumn=? WHERE id=?";
  PreparedStatement updateStat = conn.prepareStatement(updateSQL);

while (rset.next())
{
try
{
InputStream is = rset.getAsciiStream(2); 
//String summary = rset.getString(1);
//String id = rset.getString(2);
// String xml = new BufferedReader(new InputStreamReader(rset.getAsciiStream(3))).toString();
//replaceStrings(null, summary, id, updateStat);
}
catch(Exception e)
{
System.out.println("Failed for user: "+ rset.getString(1)+" Error: "+e.toString());
}
 
}

pstmt.close();
}
 

[Paul Clapham]

You never read from the InputStream in that code. Which of those statements is throwing the exception, then?