is used for mapping the SQL type
DataType::ARRAY
.
By default, an
Array
is a transaction duration
reference to an SQL array. By default, an
Array
is implemented using a SQL LOCATOR(array) internally.
returns an array containing a slice of the SQL array, beginning with the
specified
index
and containing up to
count
successive elements of the SQL array.
returns a result set that contains the elements of the array
designated by this
Array
object and uses the given
typeMap
to map the array elements. If the base
type of the array does not match a user-defined type in
typeMap
or the
typeMap
is
NULL
,
the connection type mapping is used instead.
returns a result set holding the elements of the subarray that
starts at index
index
and contains up to
count
successive elements. This method uses the given
typeMap
to map the array elements. If the base
type of the array does not match a user-defined type in
typeMap
or the
typeMap
is
NULL
,
the connection type mapping is used instead.
returns the SQL type name of the elements in
the array designated by this
Array
object.
If the elements are a built-in type, it returns
the database-specific type name of the elements.
If the elements are a user-defined type (UDT),
this method returns the fully-qualified SQL type name.
Returns
a String that is the database-specific name for a built-in base type or the fully-qualified SQL type name for a base type that is a UDT
retrieves the contents of the SQL array designated by this
Array
object, using the specified
typeMap
for type map customizations.
If the base type of the array does not match a user-defined type
in
typeMap
, the standard mapping is used instead.
Parameter typeMap
is a map object that contains mappings of SQL type names to
services. If the
typeMap
is
NULL
, the type-map
associated with the connection for customizations of the type-mappings
is used.
Returns
an sequence that contains the ordered elements
of the SQL array designated by this object.
Throws
SQLException
if an error occurs while attempting to access the array.
returns an array containing a slice of the SQL array, beginning with the
specified
index
and containing up to
count
successive elements of the SQL array.
Parameter index
is the array index of the first element to retrieve;
the first element is at index 1.
Parameter count
is the number of successive SQL array elements to retrieve.
Parameter typeMap
is a map object that contains mappings of SQL type names to
services. If the
typeMap
is
NULL
, the type-map
associated with the connection for customizations of the type-mappings
is used.
Returns
an array containing up to
count
consecutive elements
of the SQL array, beginning with element
index
.
Throws
SQLException
if an error occurs while attempting to access the array.
returns a result set that contains the elements of the array
designated by this
Array
object and uses the given
typeMap
to map the array elements. If the base
type of the array does not match a user-defined type in
typeMap
or the
typeMap
is
NULL
,
the connection type mapping is used instead.
The result set contains one row for each array element, with
two columns in each row. The second column stores the element
value; the first column stores the index into the array for
that element (with the first array element being at index 1).
The rows are in ascending order corresponding to
the order of the indices.
Parameter typeMap
contains mapping of SQL user-defined types to classes in the UNO programming language
Returns
a ResultSet object containing one row for each of the elements in the array designated by this Array object,
with the rows in ascending order based on the indices.
returns a result set holding the elements of the subarray that
starts at index
index
and contains up to
count
successive elements. This method uses the given
typeMap
to map the array elements. If the base
type of the array does not match a user-defined type in
typeMap
or the
typeMap
is
NULL
,
the connection type mapping is used instead.
The result set contains one row for each array element, with
two columns in each row. The second column stores the element
value; the first column stores the index into the array for
that element (with the first array element being at index 1).
The rows are in ascending order corresponding to
the order of the indices.
Parameter index
the array index of the first element to retrieve; the first element is at index 1.
Parameter count
the number of successive SQL array elements to retrieve,
Parameter typeMap
the Map object that contains the mapping of SQL type names to classes in the UNO programming language.
Returns
a ResultSet object containing up to count consecutive elements of the SQL array
designated by this Array object, starting at index index.
