File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes clob and blob Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "clob and blob" Watch "clob and blob" New topic
Author

clob and blob

ajay verma
Ranch Hand

Joined: Dec 10, 2007
Posts: 37
i do not know about character large object as well as binary large object.how these are related with jdbc?

kindly guide me with proper answer!


thanks
Santhosh Kumar Nunna
Greenhorn

Joined: Feb 11, 2008
Posts: 7
Hai BLOB and CLOB are used for Storing the Large Objects in a Database Table.
BLOB -> Binary Large Object
CLOB -> Character Large Object

You can define any cloumn in a Table as BLOB or CLOB. Only one Column will be allowed as BLOB or CLOB in a Table.
Swosti Dipan Pal
Ranch Hand

Joined: Sep 23, 2005
Posts: 70
Any idea how to display the content of the blob in a jsp. I don't know what is being stored in the blob ?


Thanks<br />-Swosti
Austin Lee
Ranch Hand

Joined: Feb 18, 2008
Posts: 56
Originally posted by Swosti Dipan Pal:
Any idea how to display the content of the blob in a jsp. I don't know what is being stored in the blob ?


As I think, the blob is a file stroed in the oracle. For example, image,wav,and Etc.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: clob and blob