0 Replies Latest reply on Oct 28, 2002 7:12 PM by Tom Wnuk

    Using CLOBs from Oracle 8

    Tom Wnuk Newbie

      I'm using JBoss 3.0.2 w/Oracle 8.1.6 on Win2k Pro.

      I can't seem to read Clob data from the database. I get the same results using getAsciiStream() or getCharacterStream.

      StringBuffer dataStr = new StringBuffer();
      Reader r = rs.getClob("note").getCharacterStream();
      BufferedReader br = new BufferedReader(r);

      if (br.ready())
      {
      int c;
      // ALWAYS returns -1
      while ( (c = br.read()) != -1)
      {
      dataStr.append( (char) c);
      }
      }

      I'm using the thin driver found in classes12.zip.

      Thanks Much.
      Tom