Important considerations when using BLOB and CLOB data types

BLOB and CLOB are data types used in databases to store substantial amounts of data. The section describes the important considerations by using the BLOB and CLOB data types.

• When handling CLOB or BLOB data, use the Java™ data types java.io.Reader for CLOB and java.io.InputStream for BLOB to prevent database connector from running out of memory. When using these data types, the database connector Streams the data into bytes thus allowing it to pass data efficiently. The data types java.io.Reader and java.io.InputStream are supported just for the Oracle database that uses the Oracle driver.
• When using the CLOB data with java.io.Reader as the input data type, you can use the InputStreamReader implementation of java.io.Reader with the correct encoding parameter.
• When IBM® webMethods Integration runs a SELECT operation that has its output type set to java.sql.Blob for a BLOB data type, IBM webMethods Integration issues a java.io.NotSerializableException error.