Integration Cloud 6.1.0 | Applications | Predefined Applications | Database | JDBC Data Type to Java Data Type Mappings | Important Considerations When Using the Array and Struct Database Specific Data Types
 
Important Considerations When Using the Array and Struct Database Specific Data Types
*In database operation, when using the java.lang.Object as the output field type for a database column of type ARRAY or STRUCT, Database Application returns the data as a java.lang.Object array, provided that the ARRAY or STRUCT data in the database table is composed of primitive data types.
*When using the java.sql.Array or java.sql.Struct as the output field type for a database column of type ARRAY or STRUCT, Database Application returns the java.sql.Array and the java.sql.Struct objects, respectively, as returned by the driver. However, when serializing the data across the JVMs, this returned data may not be serializable and may result into a java.io.NotSerializableException. Therefore, before serializing the data across the JVMs, it is important that you use Integration to process the java.sql.Struct and java.sql.Array objects as required, and then drop them from the pipeline.
Note:
The java.sql.Struct and java.sql.Array data types are available only for Database Application operations.