Java Programming with Oracle JDBC

Oracle’s Implementations

The three JDBC interfaces we have examined in this chapter, java.sql.Struct, java.sql.Array, and java.sql.Ref, are implemented by the Oracle classes oracle.sql.STRUCT, oracle.sql.ARRAY, and oracle.sql.REF. In addition to the standard interface implementations, Oracle has two descriptor classes, oracle.sql.StructDescriptor and oracle.sql.ArrayDescriptor, used in conjunction with the STRUCT and ARRAY constructors to create new instances of the Struct and Array classes. This section documents the Oracle proprietary classes for the descriptors and the proprietary methods for all five classes.

ArrayDescriptor

The oracle.sql.ArrayDescriptor class extends java.lang.Object. An ArrayDescriptor object is input to the constructor for oracle.sql.ARRAY to create a new instance of ARRAY. It defines the SQL ARRAY characteristics as they are specified in the database. To create a new ArrayDescriptor, call the ArrayDescriptor class’s createDescriptor( ) factory method, passing a database type name as a String and passing a Connection. The ArrayDescriptor class has the following constants:

TYPE_NESTED_TABLE
TYPE_VARRAY

The ArrayDescriptor class also has the following methods, all of which can throw a SQLException:

static ArrayDescriptor createDescriptor(String name, Connection conn)
int getArrayType(  )
String getBaseName(  )
int getBaseType(  )
long getMaxLength(  )
String getName(  )

ARRAY Implements Array

The oracle.sql.ARRAY class implements the java.sql.Array interface. An ARRAY ...