Hi Paul,
We have already done with Oracle what you are asking for. As someone
else pointed out, we just use a servlet that gets the images from the
database using java.sql.ResultSet.getBinaryStream(). This servlet gets
the image, sets the content type accordingly and then just writes the
image content to the response output stream. You just have to provide
your servlet with enough information to be able to rerieve the image, so
the link in your html page would look something like...:
<img src="/servlet/my.ImageServlet?image_code=X" /> Then you can alias
your servlet, pass the image code as part of the URL etc to make it
nicer, but I hope you get the basic idea. You might also try to optimise
it by implementing a "cache" of the already extracted images somewhere
in your filesystem but that's lef as an exercise to get a higher grade
;).
regards,
Dan
Paul Kofon wrote:
>
> Hi,
>
> Phew! I think I'll just use my solution for now. In future I'll look at
> yours, perhaps when I get Informix. Hypersonic isn't that sophisticated. As
> far as I know (I have checked it out but I'm not 100% sure) it doesn't
> support BLOBs. Thanks a lot for your help.
>
> Regards,
>
> Paul
