| title | getBinaryStream Method (int) |
|---|---|
| description | getBinaryStream Method (int) |
| author | David-Engel |
| ms.author | davidengel |
| ms.date | 01/19/2017 |
| ms.service | sql |
| ms.subservice | connectivity |
| ms.topic | reference |
| apilocation | sqljdbc.jar |
| apiname | SQLServerResultSet.getBinaryStream (int) |
| apitype | Assembly |
[!INCLUDEDriver_JDBC_Download]
Retrieves the value of the designated column index in the current row of this SQLServerResultSet object as a binary stream of uninterpreted bytes.
public java.io.InputStream getBinaryStream(int columnIndex)
columnIndex
An int that indicates the column index.
An InputStream object.
This getBinaryStream method is specified by the getBinaryStream method in the java.sql.ResultSet interface.
This method can be used only with [!INCLUDEssNoVersion] data types of binary, varbinary, varbinary(max), and image. Trying to use it with other data types will cause an exception to be thrown.
After this method gets the value as a stream, the value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.
Note
All the data in the returned stream must be read before getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream can return 0 when the method InputStream.available is called, whether there is data available or not.
getBinaryStream Method (SQLServerResultSet)
SQLServerResultSet Members
SQLServerResultSet Class