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

Updates the designated column with an ASCII 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 updateAsciiStream(java.lang.String columnName,
                              java.io.InputStream streamValue,
                              long length)

Parameters

columnName

A String that contains the column name.

streamValue

An InputStream object.

length

The length of the stream.

Exceptions

SQLServerException

Remarks

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

This method passes ASCII characters (bytes) from an InputStream object to convertible character columns, which are the ASCII range [0x00 – 0x7F] of Unicode, and 874, 932, 936, 949, 950, and 1250 through 1258 code pages. This method performs a conversion to the destination collation page. Trying to update an unconvertible destination column will cause an exception to be thrown. For binary columns, raw bytes are passed.

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 updateAsciiStream 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

updateAsciiStream Method (SQLServerResultSet)
SQLServerResultSet Methods
SQLServerResultSet Members