Integration Cloud 7.0.0 | Applications | Predefined Applications | Database | JDBC Data Type to Java Data Type Mappings | Important Considerations When Using BLOB and CLOB Data Types
 
Important Considerations When Using BLOB and CLOB Data Types
*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 Database Application from running out of memory. When using these data types, Database Application 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 Integration Cloud executes a SELECT operation that has its output type set to java.sql.Blob for a BLOB data type, Integration Cloud issues a java.io.NotSerializableException error. The work around for this issue is to use with Integration.