Member Avatar for fpaquin

Hi to all,

I am using Java version 1.3 with IBM Websphere and DB2. I would like to create a page that you can save and retrieve an image from DB2 and post it on a web page using a stored procedure. My questions are:

1. How should I create the database table. Using varchar?
2. Since the stored procedure will return a string of hexadecimal characters (representing the image), which tag should I use to display theses hex chars on the screen?
3. How should I go about saving a picture on a database table?

Thank you very much,

Francis

  • 2 Contributors
  • 2 Replies
  • 117 Views
  • 23 Hours Discussion Span
  • Latest Post Latest Post by fpaquin
Member Avatar for techniner

Save it in the table as binary and retrieve it as such using content type image/jpg.

Member Avatar for fpaquin

Can you give an example on how to code this in a JSP file. I also want to add other HTML content (i.e. tables, other texts)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.