IPreparedStatement.SetNClob Method

Definition

Namespace:

Java.Sql

Assembly:

Mono.Android.dll

Overloads

SetNClob(Int32, Reader)	Sets the designated parameter to a Reader object.
SetNClob(Int32, INClob)	Sets the designated parameter to a java.sql.NClob object.
SetNClob(Int32, Reader, Int64)	Sets the designated parameter to a Reader object.

SetNClob(Int32, Reader)

Sets the designated parameter to a Reader object.

[Android.Runtime.Register("setNClob", "(ILjava/io/Reader;)V", "GetSetNClob_ILjava_io_Reader_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetNClob (int parameterIndex, Java.IO.Reader? reader);

[<Android.Runtime.Register("setNClob", "(ILjava/io/Reader;)V", "GetSetNClob_ILjava_io_Reader_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetNClob : int * Java.IO.Reader -> unit

Parameters

parameterIndex

Int32

index of the first parameter is 1, the second is 2, ...

reader

Reader

An object that contains the data to set the parameter value to.

Attributes

RegisterAttribute

Exceptions

SQLException

if a database error happens.

Remarks

Sets the designated parameter to a Reader object. This method differs from the setCharacterStream (int, Reader) method because it informs the driver that the parameter value should be sent to the server as a NCLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGNVARCHAR or a NCLOB

<B>Note:</B> Consult your JDBC driver documentation to determine if it might be more efficient to use a version of setNClob which takes a length parameter.

Added in 1.6.

Java documentation for java.sql.PreparedStatement.setNClob(int, java.io.Reader).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

SetNClob(Int32, INClob)

Sets the designated parameter to a java.sql.NClob object.

[Android.Runtime.Register("setNClob", "(ILjava/sql/NClob;)V", "GetSetNClob_ILjava_sql_NClob_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetNClob (int parameterIndex, Java.Sql.INClob? value);

[<Android.Runtime.Register("setNClob", "(ILjava/sql/NClob;)V", "GetSetNClob_ILjava_sql_NClob_Handler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetNClob : int * Java.Sql.INClob -> unit

Parameters

parameterIndex

Int32

of the first parameter is 1, the second is 2, ...

value

INClob

the parameter value

Attributes

RegisterAttribute

Exceptions

SQLException

if a database error happens.

Remarks

Sets the designated parameter to a java.sql.NClob object. The driver converts this to a SQL NCLOB value when it sends it to the database.

Added in 1.6.

Java documentation for java.sql.PreparedStatement.setNClob(int, java.sql.NClob).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.

SetNClob(Int32, Reader, Int64)

Sets the designated parameter to a Reader object.

[Android.Runtime.Register("setNClob", "(ILjava/io/Reader;J)V", "GetSetNClob_ILjava_io_Reader_JHandler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetNClob (int parameterIndex, Java.IO.Reader? reader, long length);

[<Android.Runtime.Register("setNClob", "(ILjava/io/Reader;J)V", "GetSetNClob_ILjava_io_Reader_JHandler:Java.Sql.IPreparedStatementInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetNClob : int * Java.IO.Reader * int64 -> unit

Parameters

parameterIndex

Int32

index of the first parameter is 1, the second is 2, ...

reader

Reader

An object that contains the data to set the parameter value to.

length

Int64

the number of characters in the parameter data.

Attributes

RegisterAttribute

Exceptions

SQLException

if a database error happens.

Remarks

Sets the designated parameter to a Reader object. The reader must contain the number of characters specified by length otherwise a SQLException will be generated when the PreparedStatement is executed. This method differs from the setCharacterStream (int, Reader, int) method because it informs the driver that the parameter value should be sent to the server as a NCLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be sent to the server as a LONGNVARCHAR or a NCLOB

Added in 1.6.

Java documentation for java.sql.PreparedStatement.setNClob(int, java.io.Reader, long).

Portions of this page are modifications based on work created and shared by the Android Open Source Project and used according to terms described in the Creative Commons 2.5 Attribution License.