What does it mean to "materialize" data?

Joe Sam Shirah

This term generally refers to Array, Blob and Clob data which is referred to in the database via SQL locators ( see What is an SQL Locator? ) "Materializing" the data means to return the actual data pointed to by the Locator.

For Arrays, use the various forms of getArray() and getResultSet().

For Blobs, use getBinaryStream() or getBytes(long pos, int length).

For Clobs, use getAsciiStream() or getCharacterStream().