aspose file tools*
The moose likes JDBC and the fly likes How do i not read a whole blob into memory when using Abator generated DAO? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "How do i not read a whole blob into memory when using Abator generated DAO? " Watch "How do i not read a whole blob into memory when using Abator generated DAO? " New topic
Author

How do i not read a whole blob into memory when using Abator generated DAO?

Harry Brearley
Greenhorn

Joined: Feb 15, 2006
Posts: 15
Hi

I have successfully gerenated a DAO ibatos interface using Abator for Ibatis that contains a BLOB field.
I see the getter/setter methods for getting this data. My concern is that this approach seems to first read the whole BLOB into memory and then i pass it out to an outstream. The servlet is simply serving an image from the database. The files could be quite big and i could have many users in parallel. I am concerned about running out of memory.
I see in basis resultset you can use getBinaryStream on the blob and then read in and out as normal.

Can someone help me understand how to do this with Abator/Ibatis or whether in reality i will not have a problem?

thanks
/harry
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: How do i not read a whole blob into memory when using Abator generated DAO?