Skip to content

Latest commit

 

History

History
71 lines (53 loc) · 2.87 KB

File metadata and controls

71 lines (53 loc) · 2.87 KB
title updateBinaryStream Method (java.io.InputStream, int) | Microsoft Docs
ms.custom
ms.date 01/19/2017
ms.prod sql
ms.prod_service drivers
ms.service
ms.component jdbc
ms.reviewer
ms.suite sql
ms.technology
drivers
ms.tgt_pltfrm
ms.topic article
apiname
SQLServerResultSet.updateBinaryStream (java.lang.String, java.io.InputStream, int)
apilocation
sqljdbc.jar
apitype Assembly
ms.assetid 9be246a7-85fa-49fc-ad79-aabe97f5b280
caps.latest.revision 21
author MightyPen
ms.author genemi
manager craigg
ms.workload Inactive

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

[!INCLUDEDriver_JDBC_Download]

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

Syntax

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

Parameters

columnLabel

AStringthat contains the column label.

x

An InputStream object.

length

An int 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 [!INCLUDEssNoVersion] 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 that 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

updateBinaryStream Method (SQLServerResultSet)
SQLServerResultSet Members
SQLServerResultSet Class