What does it mean to "materialize" data?

Created May 7, 2012

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().

0 Comments (click to add your comment)

Comment and Contribute

Advertiser Disclosure: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.