Share via

updateBinaryStream Method (java.lang.String, java.io.InputStream, long)

  • Article

Updates the designated column with a binary stream value, which will have the specified number of bytes.

Note

This feature is introduced starting with the Microsoft SQL Server JDBC Driver version 2.0.

public void updateBinaryStream(java.lang.String columnLabel,
                               java.io.InputStream x,
                               long length)

Parameters

columnLabel

A String that contains the column label.

x

An InputStream object.

length

A long that indicates the length of the stream.

Exceptions

SQLServerException

Remarks

This updateBinaryStream method is specified by the updateBinaryStream method in the java.sql.ResultSet interface.

This method passes bytes from an InputStream object to selected SQL Server binary columns such as binary, varbinary, varbinary(max), image, xml, and udt. Updating character columns is not supported with this method. To update character columns with an InputStream, use the updateAsciiStream method.

If the length of the stream is different than what is specified in the length parameter, the JDBC driver throws an exception when the row is updated or inserted.

If the length of the stream is unknown, the length parameter may be set to -1 to indicate that the driver should accept the stream regardless of its length. With sqljdbc4.jar, we recommend that you use the JDBC 4.0 method updateBinaryStream Method (java.lang.String, java.io.InputStream) when the application wants to update the column from a stream whose length is unknown.

See Also

Reference

SQLServerResultSet Class

Concepts

updateBinaryStream Method (SQLServerResultSet)
SQLServerResultSet Methods
SQLServerResultSet Members