RE: Downloading BLOBS from Oracle DB

Hi,

 

 I have done something similar with image files..

 

 You need to create a special Presentation Object for your docs.

 

  import com.lutris.appserver.server.httpPresentation.*;

  public abstract class myDocPo implements HttpPresentation { ,,, }

 

 

In you run() method you you need to set the content-type, and length..

 

    public void run(HttpPresentationComms comms)
        throws Exception {
//        initSessionData(comms);

 

       comms.response.setContentType(   insert whatever the type is for MS word docs...   );
       comms.response.setContentLength(docLength);

 

//   Then you need to write the output to the user's browser..

 

       comms.response.getOutputStream().write(buf,0,rlen);
       comms.response.flush();

}

 

Sorry I don't have a complete example that would make any sense to you...

 

Hope this helps.

 

Mike.

 

-----Original Message-----
From: Sreedhar.Gajula@xxxxxx [mailto:Sreedhar.Gajula@xxxxxx]
Sent: Tuesday, January 21, 2003 3:07 PM
To: enhydra@xxxxxxxxxxx
Subject: Enhydra: Downloading BLOBS from Oracle DB

Hi There,

I am trying to download a blob containing a MS word document from an Oracle DB.
I was able to read the blob and create a .doc file on the server and created an hyper link to open in the webserver.
I was wondering if there is a way to automatically create the doc file on the fly without having to create the file on the server.

BTW I was searching on google and found your message about the same problem.

Appreciate any ideas on this.

Thanks

Sreedhar Gajula