Array

Represents an ARRAY value.

Methods
void free()
Release all resources of this object.
Object getArray()
Returns the value as a Java array.
Object getArray(Map map)
Returns the value as a Java array.
Object getArray(long index, int count)
Returns the value as a Java array.
Object getArray(long index, int count, Map map)
Returns the value as a Java array.
int getBaseType()
Returns the base type of the array.
String getBaseTypeName()
Returns the base type name of the array.
ResultSet getResultSet()
Returns the value as a result set.
ResultSet getResultSet(Map map)
Returns the value as a result set.
ResultSet getResultSet(long index, int count)
Returns the value as a result set.
ResultSet getResultSet(long index, int count, Map map)
Returns the value as a result set.

void free()

Release all resources of this object.

Object getArray() throws SQLException

Returns the value as a Java array. This method always returns an Object[].

Returns:
the Object array
Throws:
SQLException

Object getArray(Map map) throws SQLException

Returns the value as a Java array. This method always returns an Object[].

Parameters:
map - is ignored. Only empty or null maps are supported
Returns:
the Object array
Throws:
SQLException

Object getArray(long index, int count) throws SQLException

Returns the value as a Java array. A subset of the array is returned, starting from the index (1 meaning the first element) and up to the given object count. This method always returns an Object[].

Parameters:
index - the start index of the subset (starting with 1)
count - the maximum number of values
Returns:
the Object array
Throws:
SQLException

Object getArray(long index, int count, Map map) throws SQLException

Returns the value as a Java array. A subset of the array is returned, starting from the index (1 meaning the first element) and up to the given object count. This method always returns an Object[].

Parameters:
index - the start index of the subset (starting with 1)
count - the maximum number of values
map - is ignored. Only empty or null maps are supported
Returns:
the Object array
Throws:
SQLException

int getBaseType() throws SQLException

Returns the base type of the array. This database does support mixed type arrays and therefore there is no base type.

Returns:
Types.NULL
Throws:
SQLException

String getBaseTypeName() throws SQLException

Returns the base type name of the array. This database does support mixed type arrays and therefore there is no base type.

Returns:
"NULL"
Throws:
SQLException

ResultSet getResultSet() throws SQLException

Returns the value as a result set. The first column contains the index (starting with 1) and the second column the value.

Returns:
the result set
Throws:
SQLException

ResultSet getResultSet(Map map) throws SQLException

Returns the value as a result set. The first column contains the index (starting with 1) and the second column the value.

Parameters:
map - is ignored. Only empty or null maps are supported
Returns:
the result set
Throws:
SQLException

ResultSet getResultSet(long index, int count) throws SQLException

Returns the value as a result set. The first column contains the index (starting with 1) and the second column the value. A subset of the array is returned, starting from the index (1 meaning the first element) and up to the given object count.

Parameters:
index - the start index of the subset (starting with 1)
count - the maximum number of values
Returns:
the result set
Throws:
SQLException

ResultSet getResultSet(long index, int count, Map map) throws SQLException

Returns the value as a result set. The first column contains the index (starting with 1) and the second column the value. A subset of the array is returned, starting from the index (1 meaning the first element) and up to the given object count.

Parameters:
index - the start index of the subset (starting with 1)
count - the maximum number of values
map - is ignored. Only empty or null maps are supported
Returns:
the result set
Throws:
SQLException