You should use a straigt JDBC ResultSet, get the InputStream and write it to a file for further use.  Or if possible, stream it directly to the browser (maybe with a file buffer/cache).  You shouldn't  keep 20 MB of data in memory regardless of how you get it there.

Clinton


On 9/18/06, soussou97 <dboussebha@yahoo.fr> wrote:

Hi Larry;

OK I willl ue JDBC + Rowset for getting the blob, have you a example or a
implementaition ?

Regards;


Larry Meadors-2 wrote:
>
> For 20M of data? No.
>
> Larry
>
>
> On 9/18/06, soussou97 <dboussebha@yahoo.fr> wrote:
>>
>> Hi;
>>
>> Please somebody can answer me if  its possible to use Ibatis (last
>> version)
>> for getting a big Blob (20 Mo) from a database (Oracle 10) with of the
>> good
>> performance ?
>> If yes which lib (InputStream or sql.Blob) I must to use for extracting
>> the
>> data inside of blob (byte []) ?
>>
>> regards;
>> --
>> View this message in context:
>> http://www.nabble.com/Ibatis-and-the-blob-tf2290439.html#a6361369
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>
>

--
View this message in context: http://www.nabble.com/Ibatis-and-the-blob-tf2290439.html#a6362935
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.