image retrieval from sql server using java

[ravee]

Hi,
our clients have a sql server database in which one of the table column of image data type holds a image. The problem is, the column holds image along with some other data which they are doing by using some appendchunk method from VB. they are able to retrieve the image from the column with the help of a method called GetChunk in VB, now i have to do the same thing from java but I am not able to retrieve the image. I have tried resultset.getBytes() & getBinaryStream() by (they are giving the image size in another column) using the imgsize column, I have tried retrieving only certain no of bytes, but not able to see the image. If any body knows about this issue plz reply.......
Following is the method they are using to retrieve the image using VB code:
GetChunk(0, recset("imgsize") * 2)

[skaspersen]

You need to access the column as a blob.

Code:

   Blob blob = resultSet.getBlob("imgColumn");
   BufferedInputStream in = new
     BufferedInputStream(blob.getBinaryStream());

Then use in as if it were a file

HTH
Stephen

[ravee]

I have tried like this, but not working...

Quote:

Originally Posted by skaspersen

You need to access the column as a blob.

Code:

   Blob blob = resultSet.getBlob("imgColumn");
   BufferedInputStream in = new
     BufferedInputStream(blob.getBinaryStream());

Then use in as if it were a file

HTH
Stephen

[fishtoprecords]

What, specifically, is not working?

Are you getting the bytes and can't display them? or can't get the bytes?

As a test, retreive the bytes and write them out to a file and try to open the file with an image viewer program

[ravee]

I am able to get the bytes, but its not able to show the image...
they are inserting the image by using some AppendChunk method in VB and as a proof they are able to get the image properly by using a method called GetChunk. From net I came to know that GetChunk returns bytes only, but when I try to get the image from java its not getting retrieved properly. Can u plz tell if there is any specific procedure to retrieve the image if it is inserted by using AppendChunk. some method like that of GetChunk in VB...

[skaspersen]

What format is the image? Is it BMP?
Java does not display a windows bitmap file, you have to write your own decoder.

Have you written the data to a file and tried to open it from an external image viewer eg "Windows Picture and Fax Viewer" as fishtoprecords suggested?

Is the column type on the server varchar? If so you may have this problem The getBytes function incorrectly converts the raw bytes in the varchar data type column to the lower byte of the Unicode representation in the SQL Server 2000 Driver for JDBC

[ravee]

1. I tried viewing the file using Windows Picture and Fax Viewer, no result...
2. No the column type is image.