8.6.82 getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)

(1) Function

This method acquires information about the user-defined types (UDTs).

To Page Top

(2) Format

public synchronized ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException

To Page Top

(3) Arguments

String catalog

Specifies a catalog name. This argument is ignored, if specified.

String schemaPattern

Specifies a schema name pattern. This value is case sensitive.

String tableNamePattern

Specifies a table name pattern. This value is case sensitive.

int[] types

Specifies a list of the user-defined types. This value is case sensitive.

To Page Top

(4) Return value

This method always returns a ResultSet object that contains no retrieval result rows. The following table shows the format of the ResultSet object that is returned.

Table 8‒67: Format of the ResultSet object that is returned (getUDTs method)

Column No.	Type	Column name	Description
1	String	TYPE_CAT	Catalog name
2	String	TYPE_SCHEM	Schema name
3	String	TYPE_NAME	Type name
4	String	CLASS_NAME	Java class name
5	int	DATA_TYPE	Type value defined by java.sql.Types
6	String	REMARKS	Description of the type
7	short	BASE_TYPE	Type code of DISTINCT-type source or type code of an implementation of the SELF_REFERENCING_COLUMN user-defined reference type of a structure type defined by java.sql.Types

To Page Top

(5) Exceptions

If this Connection object is closed before this method is executed, the JDBC driver throws an SQLException.

To Page Top