English

Problem: ArcSDE 8.1 Java API - BLOB columns

Description

Using certain methods of the Java API, BLOB columns are returned as NULL, even if the content of the column is not NULL.

Cause

This occurs when BLOBs are fetched using the execute/fetch method of retrieval.

Fetching BLOBs from an ArcSDE table or layer using the stream buffer has not yet been implemented.

Solution or Workaround

BLOB values can be fetched from rows in a table or layer by using the method of fetching a single row at a time, rather than executing the stream and then fetching the resulting rows.

Use:

Code:
eQuery.fetchRow(...)

Rather than:
Code:
SeQuery.execute()
SeQuery.fetch()