Class JdbcArray

  • JdbcArray represents a JDBCArray and provides methods for interacting with SQL array values.

  • Methods likegetArray() andgetArray(index, count) retrieve elements of the SQL array.

  • Information about the base type of the array elements can be obtained usinggetBaseType() andgetBaseTypeName().

  • ThegetResultSet() andgetResultSet(index, count) methods return aJdbcResultSet containing array elements.

JdbcArray

A JDBCArray. For documentation of this class, seejava.sql.Array.

Methods

MethodReturn typeBrief description
free()voidFor documentation of this method, seejava.sql.Array#free().
getArray()ObjectFor documentation of this method, seejava.sql.Array#getArray()
getArray(index, count)ObjectFor documentation of this method, seejava.sql.Array#getArray(long, int).
getBaseType()IntegerFor documentation of this method, seejava.sql.Array#getBaseType().
getBaseTypeName()StringFor documentation of this method, seejava.sql.Array#getBaseTypeName().
getResultSet()JdbcResultSetFor documentation of this method, seejava.sql.Array#getResultSet().
getResultSet(index, count)JdbcResultSetFor documentation of this method, seejava.sql.Array#getResultSet(long, int).

Detailed documentation

free()

For documentation of this method, seejava.sql.Array#free().

getArray()

For documentation of this method, seejava.sql.Array#getArray()

Return

Object — An object containing the ordered elements of the SQL array value.

getArray(index, count)

For documentation of this method, seejava.sql.Array#getArray(long, int).

Parameters

NameTypeDescription
indexIntegerThe array index of the first element to retrieve, where the first element has an index of 1.
countIntegerThe number of successive SQL array elements to retrieve.

Return

Object — An object containing up to the specified number of consecutive SQL array elements.

getBaseType()

For documentation of this method, seejava.sql.Array#getBaseType().

Return

Integer — Thetype code for the elements in this array.

getBaseTypeName()

For documentation of this method, seejava.sql.Array#getBaseTypeName().

Return

String — The database-specific name for the built-in base type or else the fully-qualified SQL type name for a base type that is a UDT.

getResultSet()

For documentation of this method, seejava.sql.Array#getResultSet().

Return

JdbcResultSet — TheJdbcResultSet 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.

getResultSet(index, count)

For documentation of this method, seejava.sql.Array#getResultSet(long, int).

Parameters

NameTypeDescription
indexIntegerThe array index of the first element to retrieve, where the first element has an index of 1.
countIntegerThe number of successive SQL array elements to retrieve.

Return

JdbcResultSet — AJdbcResultSet containing up to the specified number of consecutive SQL array elements.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-11 UTC.