In an adapter service, when using the java.lang.Object as the output field type for a database column of type array or struct, Adapter for JDBC 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, Adapter for JDBC 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 a Java or a flow service to process the java.sql.Struct and java.sql.Array objects as required, and then drop them from the pipeline.