aspose file tools*
The moose likes Servlets and the fly likes loading Oracle BLOBs and CLOBs Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "loading Oracle BLOBs and CLOBs" Watch "loading Oracle BLOBs and CLOBs" New topic
Author

loading Oracle BLOBs and CLOBs

achana chan
Ranch Hand

Joined: Jul 29, 2002
Posts: 277
Hi Again.
I would like to load the objects stored in an Oracle BLOB or CLOB datatype and display them on the browser along with the information related to the item.
These BLOBs and CLOBs and be almost any docflavour eg .jpg, .html, .pdf, .gif etc
In Zukowski, there was talk of using awt's "getImage(fileName)".
Most suggest extending either JFrame (implementing ImageObserver) or ExitableJFrame
Is there a recommended way to go about this ???
THX


humanum errare est.
achana chan
Ranch Hand

Joined: Jul 29, 2002
Posts: 277
I wouldn't like to use something not portable eg.
public void readBlob(int idVal)
{ Oracle.sql.BLOB myBlob = null; // not portable
#sql { select blobcol into :myBlob
from myBlobTable
where id = :idVal };
...
etc
It seems to be that using non-portable constructs defeats my purpose and the reason for migrating to JAVA in the first instance...
achana chan
Ranch Hand

Joined: Jul 29, 2002
Posts: 277
Hi !
Just in case anyone read this and is willing to comment on it...
I have one BLOB and one CLOB column in the same record.
I have been able to stream documents into and out of the BLOB's incl. MS .doc Also I have been able to get the content from BLOB and write it to a target directory.
However I am having odd problems with CLOB, a simple text file. My servlet attempts to read the CLOB and does create the output file in the target directory, but does not copy the content over. It also returns 0 for clobLength !?! Here is the stub-code :
...

...
Since the clobLength is 0, obviously it will not copy from the database CLOB to the file.
Manually change the clobLength = 8132, recompile and run, then it copies some junk to the targetFile, certainly not the textual data in the CLOB itself.
The BLOB is fine...
Can someone comment on this please and if possible, give me a hint on where I might have gone wrong with a simple text file ???
and
achana chan
Ranch Hand

Joined: Jul 29, 2002
Posts: 277
Hi All.
Just in case someone might have read this : thanks I figured out the error with the CLOB textfile.
However I would love to have your comment on how to display the BLOB on the browser...
THX
 
wood burning stoves
 
subject: loading Oracle BLOBs and CLOBs
 
Similar Threads
Q 4 C. Bauer & G. King (14): blobs and clobs
Managed Persistance
retrieving OLE object from database to web
Inserting / Retrieving a CLOB
Fit or not fit (Oracle varchar2 problem)