wood burning stoves 2.0*
The moose likes JDBC 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

Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
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.
subject: How to get the BLOB