setAsciiStream Method (int, java.io.InputStream, long)

Sets the designated parameter number to the specified java.io.InputStream object with the specified number of bytes.

Note

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

public final void setAsciiStream(int parameterIndex,
                                 java.io.InputStream x,
                                    long length)

Parameters

parameterIndex

An int that indicates the parameter number.

x

A java.io.InputStream object.

length

A long that indicates the number of bytes.

Exceptions

SQLServerException

Remarks

This setAsciiStream method is specified by the setAsciiStream method in the java.sql.PreparedStatement interface.

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 setAsciiStream Method (int, java.io.InputStream) when the application wants to update the column from a stream whose length is unknown.

See Also

Concepts

setAsciiStream Method (SQLServerPreparedStatement)
SQLServerPreparedStatement Methods
SQLServerPreparedStatement Members