Sorry, Ross, he doesn't care about doing this well. Only just doing it somehow.
On 9/27/05, Ross Gibb <[EMAIL PROTECTED]> wrote:
> I'm using DB2 with pictures stored as blobs. We have a system similar
> to what Wendy suggested. When the image is retrieved from the database
> it is sent to an image servlet that will cache the image. The browser
> then asks the image servlet for the image. The image servlet is also
> smart enough to ask the database for the image if it finds it is not
> available in the cache. I tried to write it flexibly enough so that the
> size of the image cache and the the amount of time an image stays in
> cache is flexible. Also, if this system becomes too slow we should
> easily be able to switch to a file system approach.
>
> Good luck,
>
> Ross
>
> Braun, James F wrote:
>
> >Goal: Read a blob image from an Oracle database and render it on an html
> >page using the struts framework.
> >
> >I've never found a good way to do this and I was hoping someone had a
> >"best practice" suggestion.
> >
> >I have no trouble getting the image from the database. However, I wonder
> >if there isn't a better way to display it rather than writing it to a
> >physical file and then rendering it. I'm using the <html:img tag to
> >display the image now.
> >
> >All help appreciated.
> >
> >J.
> >
> >ImputStream pictureStream;
> >ResultSet rs;
> >
> >// create the query and execute it ...
> >
> >// get the result
> >pictureStream = rs.getBinaryStream("picture");
> >
> >// I can write it to a physical file
> >File pictureFile = new File("/temp/picture.jpg");
> >
> > try
> > {
> > FileOutputStream out = new FileOutputStream(pictureFile);
> > int chunk = 0;
> > while( (chunk = pictureStream.read()) != -1)
> > {
> > out.write(chunk);
> > }
> > out.close();
> > out.flush();
> > }
> > catch(FileNotFoundException ex)
> > {
> > System.err.println("selectionForm.populate.picturefile: " +
> >ex.getMessage());
> > logger.error("selectionForm.populate.picturefile: " +
> >ex.getMessage());
> > }
> > catch(IOException ex)
> > {
> > System.err.println("selectionForm.populate.picturefile: " +
> >ex.getMessage());
> > logger.error("selectionForm.populate.picturefile: " +
> >ex.getMessage());
> > }
> >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
"You can lead a horse to water but you cannot make it float on its back."
~Dakota Jack~
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
