Nonstop Database, HiRDB Version 9 UAP Development Guide
The JDBC driver can access repetition columns using the Array class. Note the following when using each method:
Table 17-13 Object types returned by getArray
HiRDB data type | Object type |
---|---|
INTEGER | java.lang.Integer[] |
SMALLINT | java.lang.Short[] |
DECIMAL | java.math.BigDecimal[] |
FLOAT, DOUBLE PRECISION | java.lang.Double[] |
SMALLFLT, REAL | java.lang.Float[] |
CHAR | java.lang.String[] |
VARCHAR | java.lang.String[] |
NCHAR | java.lang.String[] |
NVARCHAR | java.lang.String[] |
MCHAR | java.lang.String[] |
MVARCHAR | java.lang.String[] |
DATE | java.sql.Date[] |
TIME | java.sql.Time[] |
TIMESTAMP | java.sql.Timestamp[] |
Table 17-14 Attribute values of the result sets returned by getResultSet
ResultSetMetaData class method name | Values returned by the method | |
---|---|---|
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 | ||
getColumnType | java.sql.Types.INTEGER | Depends on the database column attribute. |
getColumnTypeName | INTEGER | |
getPrecision | 10 | Depends on the database column attribute and column length. |
getScale | 0 | |
getSchemaName | null | null |
getTableName | ||
isAutoIncrement | true | false |
isCaseSensitive | false | Depends on the database column attribute. |
isCurrency | false | |
isDefinitelyWritable | ||
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 |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.