Re: Displaying image files stored in a database

2001-02-13 Thread Huibert Aalbers
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 spee

Re: Displaying image files stored in a database

2001-02-13 Thread Lauren Commons
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

Re: Displaying image files stored in a database

2001-02-13 Thread Daniel Lopez
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 co

RE: Displaying image files stored in a database

2001-02-13 Thread Meo Van Le
[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

2001-02-12 Thread Paul Kofon
. Regards, Paul >From: Huibert Aalbers <[EMAIL PROTECTED]> >Reply-To: Orion-Interest <[EMAIL PROTECTED]> >To: Orion-Interest <[EMAIL PROTECTED]> >Subject: Re: Displaying image files stored in a database >Date: Mon, 12 Feb 2001 12:28:49 -0600 > >Hi, > >I

Re: Displaying image files stored in a database

2001-02-12 Thread Vinh Chu Xuan
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 R&D Department Vietnam Data Communication Company http://home.vnn.vn/vdc/index_e.html 1E Trung Ch

Re: Displaying image files stored in a database

2001-02-12 Thread Huibert Aalbers
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 w

Re: Displaying image files stored in a database

2001-02-12 Thread nickm
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

2001-02-12 Thread nickm
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

2001-02-12 Thread nickm
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

2001-02-12 Thread nickm
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

2001-02-12 Thread Mikael Eriksson
Hi, I guess you could write the URL to all images from the database as '/databaseimage/'. 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 response. Regard