This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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!