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


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply 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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: to retrieve data from an image type in ms sql
 
Similar Threads
Which image is loading Fastly .jpg or .gif?
Image as a background
overlay jpeg with text
request.getHeader()
image conversion from jpg to jif