Columns with nested objects
- Last Updated: April 20, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- Autonomous REST Connector 6.0
- Documentation
The driver supports objects with nested objects. When generating the relational view, the driver flattens nested objects to the table of the parent object.
A column with three nested columns takes the following form for a column
with three nested objects. You can define one or more nested objects in a column definition.
"<column_name>":{
"<nested_column1>":"<data_type>",
"<nested_column2>","<data_type>",
"<nested_column3>","<data_type>"
}- column_name
- is the name of the column that contains the nested object.
- nested_column
- specifies the data type mapping for the map key.
- data_type
- specifies the data type mapping for the corresponding column.
"address":{"line1":"varchar(256)", "zip":"integer", "city":"varchar(256)"}