Streaming Columns

If the underlying object is itself an OutputStream class, getBinaryStream returns the object directly.

To get a field from the ResultSet using streaming columns, you can use the getXXXStream methods if the type supports it. See Table 10 for a list of types that support the various streams. (See also Table 12.)

You can retrieve data from one of the supported data type columns as a stream, whether or not it was stored as a stream.

The following example shows how a user can retrieve a LONG VARCHAR column as a stream:

// retrieve data as a stream 
ResultSet rs = s.executeQuery("SELECT b FROM atable");
while (rs.next()) {
     // use an InputStream to get the data 
    InputStream ip = rs.getAsciiStream(1);
     // process the stream--this is just a generic way to 
     // print the data 
    int c;
    int columnSize = 0;
    byte[] buff = new byte[128];
    for (;;) {
        int size = ip.read(buff);
        if (size == -1)
            break;
        columnSize += size;
        String chunk = new String(buff, 0, size);
        System.out.print(chunk);
    }
}
rs.close();
s.close();
conn.commit();