RE: Displaying image files stored in a database

[mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 13, 2001 1:32 PM To: Orion-Interest Subject: Re: Displaying image files stored in a database Hi, I have the same problem with Oracle Database Server 8.1.6 Please send me some information if you have any ideal I would very much appreciate your ideal

Re: Displaying image files stored in a database

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

Re: Displaying image files stored in a database

Question below... --- Huibert Aalbers [EMAIL PROTECTED] wrote: Hi, I have recently done what you are looking for using (not surprisingly if you take a look at my e-mail) an Informix database. I stored the images as blobs in the database and used a singleton class (called through a JSP

Re: Displaying image files stored in a database

Hi Lauren, Does this mean you (or the DB) retrieve the object from from the database and save it to the file system (in the document root)? That is correct. I would think this would be relatively slow. I understand you said Informix has a function to do this for you, and this may speed up

RE: Displaying image files stored in a database

Hi, I guess you could write the URL to all images from the database as '/databaseimage/primary key'. For example: '/databaseimage/13'. Then you map a servlet to /databaseimage. This servlet cheks the request URI for the primary key, reads the file from the database and then sends it on the

Re: Displaying image files stored in a database

Hi: How about creating an object that first deletes the image file referenced in the database then deletes the record itself? Stefan

Re: Displaying image files stored in a database

Hi: How about creating an object that first deletes the image file referenced in the database then deletes the record itself? Stefan

Re: Displaying image files stored in a database

Hi: How about creating an object that first deletes the image file referenced in the database then deletes the record itself? Stefan

Re: Displaying image files stored in a database

Hi, I have recently done what you are looking for using (not surprisingly if you take a look at my e-mail) an Informix database. I stored the images as blobs in the database and used a singleton class (called through a JSP custom tag) to retrieve the images to the file system and manage a cache

Re: Displaying image files stored in a database

Hi, I have the same problem with Oracle Database Server 8.1.6 Please send me some information if you have any ideal I would very much appreciate your ideal. Thanks Best regards, Vinh Chu Xuan Software RD Department Vietnam Data Communication Company http://home.vnn.vn/vdc/index_e.html 1E Trung