title: How to append text to an oracle clob
body: <p>Is it possible to append text to an oracle 9i clob without rereading and rewriting the whole content?</p>
  
  <p>I have tried this:</p>
  
  <pre><code>PreparedStatement stmt = cnt.prepareStatement(
          "select OUT from QRTZ_JOBEXEC where EXEC_ID=? "
              + "for update",
          ResultSet.TYPE_FORWARD_ONLY,
          ResultSet.CONCUR_UPDATABLE);
  try {
      stmt.setLong(1, id);
      ResultSet rs = stmt.executeQuery();
      if (rs.next()) {
          Clob clob = rs.getClob(1);
          long len = clob.length();
          Writer writer = clob.setCharacterStream(len+1);
          try {
              PrintWriter out = new PrintWriter(writer);
              out.println(line);
              out.close();
          } finally {
              writer.close();
          }
          rs.updateClob(1, clob);
          rs.updateRow();
      }
      rs.close();
  } finally {
      stmt.close();
  }
  </code></pre>
  
  <p>But I'm getting an "Unsupported feature" exception on the call to setCharacterStream.</p>