Udostępnij za pośrednictwem

IRowSet.SetClob Method

  • Reference

Definition

Namespace:
Javax.Sql
Assembly:
Mono.Android.dll

Overloads

SetClob(Int32, Reader)

Sets the designated parameter to a Reader object.
SetClob(Int32, IClob)

Sets the designated parameter in this RowSet object's command with the given Clob value.
SetClob(String, Reader)

Sets the designated parameter to a Reader object.
SetClob(String, IClob)

Sets the designated parameter to the given java.sql.Clob object.
SetClob(Int32, Reader, Int64)

Sets the designated parameter to a Reader object.
SetClob(String, Reader, Int64)

Sets the designated parameter to a Reader object.

SetClob(Int32, Reader)

Sets the designated parameter to a Reader object.

[Android.Runtime.Register("setClob", "(ILjava/io/Reader;)V", "GetSetClob_ILjava_io_Reader_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetClob (int parameterIndex, Java.IO.Reader? reader);
[<Android.Runtime.Register("setClob", "(ILjava/io/Reader;)V", "GetSetClob_ILjava_io_Reader_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetClob : 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 an error occurs accessing the database.

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 CLOB. 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 LONGVARCHAR or a CLOB

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

Added in 1.6.

Java documentation for javax.sql.RowSet.setClob(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.

Applies to

SetClob(Int32, IClob)

Sets the designated parameter in this RowSet object's command with the given Clob value.

[Android.Runtime.Register("setClob", "(ILjava/sql/Clob;)V", "GetSetClob_ILjava_sql_Clob_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetClob (int i, Java.Sql.IClob? x);
[<Android.Runtime.Register("setClob", "(ILjava/sql/Clob;)V", "GetSetClob_ILjava_sql_Clob_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetClob : int * Java.Sql.IClob -> unit

Parameters

i
Int32

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

x
IClob

an object representing a CLOB

Attributes
RegisterAttribute

Exceptions

SQLException

if an error occurs accessing the database.

Remarks

Sets the designated parameter in this RowSet object's command with the given Clob value. The driver will convert this to the CLOB value that the Clob object represents before sending it to the database.

Java documentation for javax.sql.RowSet.setClob(int, java.sql.Clob).

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.

Applies to

SetClob(String, Reader)

Sets the designated parameter to a Reader object.

[Android.Runtime.Register("setClob", "(Ljava/lang/String;Ljava/io/Reader;)V", "GetSetClob_Ljava_lang_String_Ljava_io_Reader_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetClob (string? parameterName, Java.IO.Reader? reader);
[<Android.Runtime.Register("setClob", "(Ljava/lang/String;Ljava/io/Reader;)V", "GetSetClob_Ljava_lang_String_Ljava_io_Reader_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetClob : string * Java.IO.Reader -> unit

Parameters

parameterName
String

the name of the parameter

reader
Reader

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

Attributes
RegisterAttribute

Exceptions

SQLException

if an error occurs accessing the database.

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 CLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGVARCHAR or a CLOB

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

Added in 1.6.

Java documentation for javax.sql.RowSet.setClob(java.lang.String, 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.

Applies to

SetClob(String, IClob)

Sets the designated parameter to the given java.sql.Clob object.

[Android.Runtime.Register("setClob", "(Ljava/lang/String;Ljava/sql/Clob;)V", "GetSetClob_Ljava_lang_String_Ljava_sql_Clob_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetClob (string? parameterName, Java.Sql.IClob? x);
[<Android.Runtime.Register("setClob", "(Ljava/lang/String;Ljava/sql/Clob;)V", "GetSetClob_Ljava_lang_String_Ljava_sql_Clob_Handler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetClob : string * Java.Sql.IClob -> unit

Parameters

parameterName
String

the name of the parameter

x
IClob

a Clob object that maps an SQL CLOB value

Attributes
RegisterAttribute

Exceptions

SQLException

if an error occurs accessing the database.

Remarks

Sets the designated parameter to the given java.sql.Clob object. The driver converts this to an SQL CLOB value when it sends it to the database.

Added in 1.6.

Java documentation for javax.sql.RowSet.setClob(java.lang.String, java.sql.Clob).

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.

Applies to

SetClob(Int32, Reader, Int64)

Sets the designated parameter to a Reader object.

[Android.Runtime.Register("setClob", "(ILjava/io/Reader;J)V", "GetSetClob_ILjava_io_Reader_JHandler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetClob (int parameterIndex, Java.IO.Reader? reader, long length);
[<Android.Runtime.Register("setClob", "(ILjava/io/Reader;J)V", "GetSetClob_ILjava_io_Reader_JHandler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetClob : 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 an error occurs accessing the database.

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 CLOB. 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 LONGVARCHAR or a CLOB

Added in 1.6.

Java documentation for javax.sql.RowSet.setClob(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.

Applies to

SetClob(String, Reader, Int64)

Sets the designated parameter to a Reader object.

[Android.Runtime.Register("setClob", "(Ljava/lang/String;Ljava/io/Reader;J)V", "GetSetClob_Ljava_lang_String_Ljava_io_Reader_JHandler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")]
public void SetClob (string? parameterName, Java.IO.Reader? reader, long length);
[<Android.Runtime.Register("setClob", "(Ljava/lang/String;Ljava/io/Reader;J)V", "GetSetClob_Ljava_lang_String_Ljava_io_Reader_JHandler:Javax.Sql.IRowSetInvoker, Mono.Android, Version=0.0.0.0, Culture=neutral, PublicKeyToken=null")>]
abstract member SetClob : string * Java.IO.Reader * int64 -> unit

Parameters

parameterName
String

the name of the parameter to be set

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 an error occurs accessing the database.

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 CallableStatement 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 CLOB. When the setCharacterStream method is used, the driver may have to do extra work to determine whether the parameter data should be send to the server as a LONGVARCHAR or a CLOB

Added in 1.6.

Java documentation for javax.sql.RowSet.setClob(java.lang.String, 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.

Applies to