aspose file tools
The moose likes JDBC and Relational Databases and the fly likes to retrieve data from an image type in ms sql Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "to retrieve data from an image type in ms sql" Watch "to retrieve data from an image type in ms sql" New topic
Author

to retrieve data from an image type in ms sql

kiran manohar
Ranch Hand

Joined: Sep 28, 2003
Posts: 49
hi,
i am having a table in ms sqlserver 2000. i am having a column called photo of image datatype in it. i need to know how to insert a gif or jpeg in that column in sqlserver.then using jdbc i need to retrieve that image (jpeg/gif)and display in my Frame.
Regards
Kiranmanohar
Peter den Haan
author
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
Not sure what the image data type is mapped to, but it might be a binary. Try ResultSet.getBinaryStream(int).
- Peter
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: to retrieve data from an image type in ms sql