Advanced Server Type to JDBC Data Type Mappings
Adapter for JDBC supports only the basic data types supported by the Postgres Plus Advanced Server 9.0 JDBC connector and listed in the following table:
JDBC Data Type | Advanced Server Type |
INTEGER | INT4 |
TINYINT, SMALLINT | INT2 |
BIGINT | INT8 |
REAL, FLOAT | FLOAT4 |
DOUBLE | FLOAT8 |
DECIMAL, NUMERIC | NUMERIC |
CHAR | BPCHAR |
VARCHAR, LONGVARCHAR | VARCHAR |
DATE | DATE |
TIME | TIME |
TIMESTAMP | TIMESTAMP |
BINARY | BYTEA |
BIT | BOOL |
Advanced Server Type Constraints
When creating tables with the NUMERIC, VARCHAR, or BYTEA data types, you must specify a length for the table.