Data Types for Reference Data Management (4.0)
Supported data types for Reference Data Management includes a list of Java SQL types retrieved via the JDBC drivers of the supported databases.
Reference Data Management currently supports Oracle and PostgreSQL. You will need to refer to the respective database JDBC driver documentations for detailed information on the database data type to Java SQL type mapping.
For unsupported data types, the following is a list of Reference Data Management features that will be impacted(where unsupported fields will be omitted from SQL statements):
Query Expressions
Edit
Insert
Export
As a quick guide, the following is a generalized table which maps the supported Java SQL types to some of the commonly used and tested PostgreSQL and Oracle data types.
Category | Java SQL Types | PostgreSQL Data Types | Oracle Data Types |
---|---|---|---|
STRING | java.sql.Types.CHAR java.sql.Types.NCHAR java.sql.Types.VARCHAR java.sql.Types.NVARCHAR | character (char) character varying (varchar) Â | CHAR VARCHAR VARCHAR2 Â |
NUMBER | java.sql.Types.SMALLINT java.sql.Types.REAL java.sql.Types.FLOAT java.sql.Types.DOUBLE java.sql.Types.INTEGER java.sql.Types.DECIMAL java.sql.Types.BIGINT java.sql.Types.TINYINT java.sql.Types.NUMERIC | numeric (decimal) integer (int, int4) bigint (int8) double precision (float8) | NUMBER FLOAT Â |
DATE/TIME | java.sql.Types.TIMESTAMP java.sql.Types.DATE java.sql.Types.TIME | timestamp date time | TIMESTAMP DATE |
BOOLEAN | java.sql.Types.BOOLEAN | boolean (bool) | Â |