Storing the ResultSet

[Goldie]

Hi,
Is there a way where I can store the result of the query as a InputStream rather than a string. The reason for me to store it as InputStream is that .. the method I am using to process the resultset accepts inputstream only.
right now I have to save the data of the resultset as a file and then get the data from the file in the same program.
Could anyone pls help me
Thanks

[Thomas Paul]

If you need to pass the entire ResultSet as one Stream then you can build a String and then create a java.io.StringBufferInputStream object.
If you want to pass individual columns then you can use either ResultSet.getAsciiStream() or ResultSet.getBinaryStream(). Both of those will take only one column at a time specified by using either an int (column number) or String (column name).

[Susan Hoover]

Would something like this work?

    ResultSet rs = stmt.executeQuery(someQuery);
    String foo = null;
    ByteArrayInputStream bais = null;
    while (rs.next()) {
        foo = rs.getString(1);
        bais = new ByteArrayInputStream(foo.getBytes());
    }
    rs.close();
    rs = null;
    if (bais != null) {
        // do something with bais
    }

Susan

[Thomas Paul]

The problem is that the creation of a new ByteArrayInputStream is inside the while loop. bais will end up only with data from the last row. How about something like this. I didn't get a chance to try it out but I think it should work.

    ResultSet rs = stmt.executeQuery(someQuery);
    String foo = null;
    InputStream is = null;
    StringBuffer s = new StringBuffer();
    while (rs.next()) {
        s.append(rs.getString(1)+ "|" + rs.getString(2) + "\n");
    }
    is = s.toString().getBytes();
    rs.close();
    rs = null;
    if (is != null) {
        // do something with is
    }

[This message has been edited by Thomas Paul (edited January 11, 2001).]