...
| User Facing Name | Type | Description | Constraints |
|---|
| Label | String | Label for UI |
|
| Host | String | Oracle host | Required (defaults to localhost on UI) |
| Port | Number | Specific port where Oracle running on | Optional (default 1521) |
| SID | String | SID name to connect | Required |
| Service name | String | Service name to connect | Required |
| Username | String | DB username | Required |
| Password | String | User password | Required |
| Connection Arguments | Keyvalue | A list of arbitrary string tag/value pairs as connection arguments, list of properties https://docs.oracle.com/cd/E11882_01/appdev.112/e13995/oracle/jdbc/OracleDriver.html
|
|
| Database Command | String | Database command to run | Valid SQL query |
| Driver type | Select | Oracle driver type | Possible values (thin, oci) |
Data Types Mapping
| 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. |
FLOATLONGDATE| 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 |
+Type is deprecated by Oracle | * | 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 |
* | 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 Oracle | Schema.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.
...