When passing large CLOB or BLOB data, use the Java data types java.io.Reader for CLOB and java.io.InputStream for BLOB to prevent Integration Server from running out of memory. When using these data types, Adapter for JDBC streams the data into bytes thus allowing to pass large data. The data types java.io.Reader and java.io.InputStream are supported only for the Oracle database using the Oracle driver.

When using the CLOB data with java.io.Reader as input data type, it is recommended that you use the InputStreamReader implementation of java.io.Reader with the correct encoding parameter.

When Designer executes a Adapter for JDBC SELECT service that has its output type set to java.sql.Blob for a BLOB data type, Designer issues a java.io.NotSerializableException error. To work around this issue, perform one of the following:

Use another valid Output Type for BLOB data types.

Execute the service by navigating through Integration Server Administrator instead of saving or viewing the BLOB data through Designer.