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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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.
