jQuery in Action, 2nd edition*
The moose likes JSP and the fly likes create a blob and wite blob to browsers Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "create a blob and wite blob to browsers " Watch "create a blob and wite blob to browsers " New topic

create a blob and wite blob to browsers

rao patwary

Joined: Mar 05, 2003
Posts: 1
Hi ,
I want to build a html text and write to string .Then i want to store the string as blob in oracle database. I wnat to retrive the blob and give excel extension and finnaly send it to browser.
Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 30068

Is there any part of this that you are having particular difficulty with? Also, as far as I know, excel doesn't open html documents.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
William Brogden
Author and all-around good cowpoke

Joined: Mar 22, 2000
Posts: 12759
BLOB implies bytes rather than characters. Since JSP is entirely oriented to making character pages, you should use a servlet to send byte data. In addition to the extension you would have to set content type and length headers. If you want Excel to read text, use comma delimited or tab delimited lines.
Consider Paul's rocket mass heater.
subject: create a blob and wite blob to browsers
Similar Threads
How to store StringBuffer contents into a blob?
how to write BLOB type of data from java application into an oracle table
Hibernate reading BinaryLargeObjects(BLOBS)
inserting BLOBs into MySQL database
How to convert "java.sql.Blob" object to "java.sql.Clob" object?