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.