You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Geoff Hollingworth <eu...@hotmail.com> on 2006/06/29 12:45:18 UTC

How do i fetch a BLOB via AbatorDAO without reading the whole BLOB into memory

normally i would fetch direct to the db with the rs and getBinaryStream type 
methods.
or should i not be worried about running out of memory because something 
clever is being done i do not understand, cannot see
thanks
/geoff



Re: How do i fetch a BLOB via AbatorDAO without reading the whole BLOB into memory

Posted by Jeff Butler <je...@gmail.com>.
iBATIS doesn't support this directly, it's default BLOB handlers turn the
BLOB into a byte[] (read the whole BLOB into memory).  That's why Abator
generates a byte[] for a BLOB.

You could make this work differently by using a row handler, or a custom
type handler, but Abator doesn't support those features of iBATIS so you're
on your own to write the sql statement and the collateral objects.

Jeff Butler


On 6/29/06, Geoff Hollingworth <eu...@hotmail.com> wrote:
>
> normally i would fetch direct to the db with the rs and getBinaryStream
> type
> methods.
> or should i not be worried about running out of memory because something
> clever is being done i do not understand, cannot see
> thanks
> /geoff
>
>
>