8.1.1 List of the methods in the Array interface

Organization of this subsection

(1) Main functions of the Array interface

The Array interface provides the following main functions for accessing columns of array type:

Retrieving SQL Array values (the values of array elements in an array-type column).
Retrieving a result set containing SQL Array values (the values of array elements in an array-type column).

The following table shows a list of Array interface methods supported by HADB.

Table 8‒1: List of Array interface methods
No.	Array interface method	Function
1	getArray()	Retrieves all array elements of an array-type column as an Object array.
2	getArray(long index, int count)	Retrieves a portion of array elements of an array-type column as an Object array.
3	getBaseType()	Retrieves the element data type of array elements in an Array object as a JDBC SQL data type.
4	getBaseTypeName()	Retrieves the element data type of array elements in an Array object using HADB data type names.
5	getResultSet()	Obtains a result set containing all array elements of an array-type column.
6	getResultSet(long index, int count)	Obtains a result set containing some array elements of an array-type column.

Important: HADB does not support methods that are not listed in this table. If an unsupported method is executed, an SQLException is thrown.

The package and class names required in order to use the Array interface are as follows: