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
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).
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.
[This message has been edited by Thomas Paul (edited January 11, 2001).]