ResultSets and streaming columns


To get a field from the ResultSet using streaming columns, you can use the getXXXStream methods if the type supports it. See Streamable JDBC data types for a list of types that support the various streams. (See also Mapping of java.sql.Types to SQL types.)


The following code fragment shows how a user can retrieve a LONG VARCHAR column as a stream:
    // retrieve data as a stream
    while ( {
        // use a to get the data ip = rs.getCharacterStream(1);

        // print the data
        char[] buff = new char[128];
        int size;
        while ((size = != -1) {