Get a Long Text Column/Field from a Database : Long Text « Database « Java Tutorial

1. Java Tutorial
2. Database
3. Long Text

public static String getLargerString(ResultSet rs, int columnIndex) throws SQLException {

    InputStream in = null;
    int BUFFER_SIZE = 1024;
    try {
      in = rs.getAsciiStream(columnIndex);
      if (in == null) {
        return "";
      }

      byte[] arr = new byte[BUFFER_SIZE];
      StringBuffer buffer = new StringBuffer();
      int numRead = in.read(arr);
      while (numRead != -1) {
        buffer.append(new String(arr, 0, numRead));
        numRead = in.read(arr);
      }
      return buffer.toString();
    } catch (Exception e) {
      e.printStackTrace();
      throw new SQLException(e.getMessage());
    }
  }