File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes How to get the BLOB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "How to get the BLOB" Watch "How to get the BLOB" New topic

How to get the BLOB

gurusamy sengodan
Ranch Hand

Joined: Oct 13, 2005
Posts: 41
I have written the JDBC Code to get the field values from the Table.
There is a BLOB field in that table.
How to get the BLOB ? What is the return type we should use.
I want to see the content of BLOB field via Java Code.

Thanks in Advance
Wei Dai
Ranch Hand

Joined: Jun 22, 2005
Posts: 86
>There is a BLOB field in that table.
Usually you can use ResultSet.getBlob(...). For Oracle driver, you need some special code.
I agree. Here's the link:
subject: How to get the BLOB
It's not a secret anymore!