ResultSet.getAsciiStream

ResultSet.getAsciiStream

Interface Overview | Interface Members | This Package | All Packages

Syntax
public abstract InputStream getAsciiStream( int columnIndex ) throws SQLException
Parameters
columnIndex
the first column is 1, the second is 2, ...
Returns
a Java input stream that delivers the database column value as a stream of one byte ASCII characters. If the value is SQL NULL then the result is null.
Description
A column value can be retrieved as a stream of ASCII characters and then read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a get method implicitly closes the stream. . Also, a stream may return 0 for available() whether there is data available or not.

Exceptions
SQLException if a database-access error occurs.