Array class

The following table lists the object types returned by this method.

Table 17-13 Object types returned by getArray

MAP cannot be used.
The result set returned by this method includes one row in each array element, and each row has two columns. The second column stores the value of the element, while the first column stores the index of the corresponding element inside the array (the index of the first array element is 1). Rows are arranged in ascending order based on the indexes.
Closing a statement also closes the result returned by this method.

The following table shows the attribute values of the result sets returned by this method.

Table 17-14 Attribute values of the result sets returned by getResultSet

ResultSetMetaData class method name	Values returned by the method
ResultSetMetaData class method name	First column	Second column
getCatalogName	null	null
getColumnClassName	java.lang.Integer	Depends on the database column attribute.
getColumnDisplaySize	10	Depends on the database column length.
getColumnLabel	JDBC_Array_Index	Depends on the database column name.
getColumnName	JDBC_Array_Index	Depends on the database column name.
getColumnType	java.sql.Types.INTEGER	Depends on the database column attribute.
getColumnTypeName	INTEGER	Depends on the database column attribute.
getPrecision	10	Depends on the database column attribute and column length.
getScale	0	Depends on the database column attribute and column length.
getSchemaName	null	null
getTableName	null	null
isAutoIncrement	true	false
isCaseSensitive	false	Depends on the database column attribute.
isCurrency		false
isDefinitelyWritable		false
isNullable	java.sql.ResultSetMetaData.columnNoNulls	Depends on the database column attribute.
isReadOnly	true	false
isSearchable	false	true
isSigned		Depends on the database column attribute.
isWritable		false

17.6 Array class