...
| Oracle Data Type | CDAP Schema Data Type | Support | Comment | ||
|---|---|---|---|---|---|
| VARCHAR2 | Schema.Type.STRING | * | No such type in java.sql.Types, mapping to String by default | + | |
| NVARCHAR2 | Schema.Type.STRING | * | No such type in java.sql.Types, mapping to String by default | + | |
| VARCHAR | Schema.Type.STRING | + | |||
| NUMBER | Schema.LogicalType.DECIMAL | + | |||
| FLOAT | Schema.Type.DOUBLE | + | FLOAT(126) by default value is represented internally as NUMBER | ||
| LONG | Schema.Type.STRING | + | Character data of variable length. | ||
| DATE | Schema.LogicalType.DATETIMESTAMP_MICROS | + | |||
| BINARY_FLOAT | Schema.Type.FLOAT | + | |||
| BINARY_DOUBLE | Schema.Type.DOUBLE | + | |||
| TIMESTAMP | Schema.LogicalType.TIMESTAMP_MICROS | + | |||
| TIMESTAMP WITH TIME ZONE | Schema.LogicalType.TIMESTAMP_MICROS | +* | Currently converted to UTC time, modifying original time zone. | ||
| TIMESTAMP WITH LOCAL TIME ZONE | Schema.LogicalType.TIMESTAMP_MICROS | + | |||
| INTERVAL YEAR TO MONTH | Schema.Type.STRING | + | |||
| INTERVAL DAY TO SECOND | Schema.Type.STRING | + | |||
| RAW | Schema.Type.BYTES | + | |||
| LONG RAW | - | Type is deprecated by OracleSchema.Type.BYTES | + | ||
| ROWID | Schema.Type.STRING | + | |||
| UROWID | Schema.Type.STRING | * | No such type in java.sql.Types, mapping to String by default | + | |
| CHAR | Schema.Type.STRING | + | |||
| NCHAR | Schema.Type.STRING | + | |||
| CLOB | Schema.Type.STRING | + | |||
| NCLOB | Schema.Type.STRING | + | |||
| BLOB | Schema.Type.BYTES | + | |||
| BFILE | - | Type is deprecated by OracleSchema.Type.BYTES | * | Deprecated by Oracle in java api, added mapping to Type.BYTES |
Approach
Create a module oracle-plugin in database-plugins project, reuse existing database-plugins code if possible. Add Oracle-specific properties to configuration, add support for Oracle-specific datatypes. Update UI widgets JSON definitions.
...