Right.  We don't make use of the JDBC Blob/Clob classes.  So you have to use
a byte[] (byte array).

However, if your BLOB is huge, you might want to stream it directly to disk,
or even directly to the browser.  In this case you'll want to bypass iBATIS,
as it likely doesn't make sense to map huge data structures to anything
resident in memory.

Cheers,
Clinton

On 12/18/06, Karen Koch <[EMAIL PROTECTED]> wrote:

Hello --

I think this is a simple one:  What is the proper resultClass to use when
returning only a single column (of BLOB type) as the result of a statement?
SqlMaps doesn't seem to like "BLOB".

 <select id="getEncryptedPassword" resultClass=???
parameterClass="string">
        SELECT Password FROM EPLoginAccount WHERE EmailAddr = #value#
 </select>

Thanks!
Karen Koch

Reply via email to