...
| Oracle Data Type | CDAP Schema Data Type | Support | Comment | |
|---|---|---|---|---|
| VARCHAR2 | Schema.Type.STRING | + | ||
| NVARCHAR2 | Schema.Type.STRING | + | ||
| 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.TIMESTAMP_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 | Schema.Type.BYTES | + | ||
| ROWID | Schema.Type.STRING | + | ||
| UROWID | Schema.Type.STRING | + | ||
| 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.
...