Desktop User Guides > JDBC Driver > UNICOM Intelligence JDBC Driver specification > Database metadata supported by the JDBC driver
 
Database metadata supported by the JDBC driver
The UNICOM Intelligence JDBC Driver supports the following metadata:
getColumns
Retrieves a description of table columns available in the specified catalog. Only column descriptions matching the catalog, schema, table and column name criteria are returned. The results are ordered by TABLE_CAT, TABLE_SCHEM, TABLE_NAME, and ORDINAL_POSITION.
ResultSet getColumns(String catalog,
                     String schemaPattern,
                     String tableNamePattern,
                     String columnNamePattern)
                     throws SQLException
The JDBC driver ignores all parameters and returns all columns. The driver returns all fields in VDATA, HDATA, array objects, and grid objects. The field name can be used in SQL.
getSchemas
Retrieves the available database schema names. The results are ordered by TABLE_CATALOG and TABLE_SCHEM.
ResultSet getSchemas()
                     throws SQLException
getTables
Retrieves a description of the tables available in the given catalog. Only table descriptions matching the catalog, schema, table name, and type criteria are returned. The results ordered by TABLE_TYPE, TABLE_CAT, TABLE_SCHEM, and TABLE_NAME.
ResultSet getTables(String catalog,
                    String schemaPattern,
                    String tableNamePattern,
                    String[] types)
throws SQLException
The JDBC driver ignores all parameters and returns all tables.
getTypeInfo
Retrieves a description of all the supported database data types. The results are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type.
If the database supports SQL distinct types, then getTypeInfo() will return a single row with a TYPE_NAME of DISTINCT and a DATA_TYPE of TYPES.DISTINCT. If the database supports SQL structured types, then getTypeInfo() returns a single row with a TYPE_NAME of STRUCT and a DATA_TYPE of Types.STRUCT. If SQL distinct or structured types are supported, then information on the individual types can be obtained from the getUDTs() method.
UNICOM Intelligence TYPE_NAME
UNICOM Intelligence data type
JDBC metadata DATA_TYPE
JDBC metadata TYPE_NAME
Java class
DOUBLE
5
8
double
java.lang.Double
LONG
3
4
integer
java.lang.Integer
DATE
7
93
timestamp
java.sql.Timestamp
BOOLEAN
11
-7
boolean
java.lang.Boolean
TEXT
130
-1
longvarchar
java.lang.String
CATEGORICAL
129
12
varchar
java.lang.String
OBJECT
128
Ignore
 
 
LEVEL
136
-2
BINARY
byte[]
See also
JDBC driver: SQL syntax
UNICOM Intelligence data types
Query from VDATA
Query from HDATA
Query grid field in HDATA
Return category value
Return level field
UNICOM Intelligence JDBC Driver specification