Extract Image from BLOB OBJ in Oracle database table

4 次查看（过去 30 天）
Sean Lawson
Sean Lawson 2011-9-1
评论： Mustafa Zendaki 2021-3-16
Hi All,
I have a oracle database with tables in it. Some of the tables have fields of (BLOB), I know that these BLOBS contain pure jpeg image.
I can export the data in BLOB as matrices by MATLAB, these matrices are all one column matrices as I expected. However, what I really need to do is to have the .jpg image output. Does anyone have any idea how I could do this in MATLAB?
  1 个评论
Mustafa Zendaki
Mustafa Zendaki 2021-3-16
can you please share the code of how you exported he blob into matlab, i would really appreciate it

请先登录，再进行评论。

请先登录，再回答此问题。

回答（2 个）

Walter Roberson
Walter Roberson 2011-9-1
If you want to display the image, you will have to write it to a file and use imread() .
There might be an undocumented method, or perhaps a JAVA method, of converting the byte stream in to an image array, but there is no documented MATLAB routine for doing this.
  1 个评论
Sean Lawson
Sean Lawson 2011-9-1
Thank you.
I do know there are some approaches in .NET, or SQL for example. But I am not sure that if matlab could do this, I do try to find some hints online but there's little. Could you tell me a little bit more?

请先登录，再进行评论。

Aleksy Barski
Aleksy Barski 2018-4-6
编辑：Aleksy Barski 2018-4-6
function [ image ] = deserializeImage( blob )
obj = blob{1,1};
is = obj.getBinaryStream();
bufferedImage = javax.imageio.ImageIO.read(is);
H = bufferedImage.getHeight;
W = bufferedImage.getWidth;
B = uint8(zeros([H,W,3]));
pixelsData = uint8(bufferedImage.getData.getPixels(0,0,W,H,[]));
for i = 1 : H
base = (i-1)*W*3+1;
B(i,1:W,:) = deal(reshape(pixelsData(base:(base+3*W-1)),3,W)');
end
image = B;
clear bufferedImage;
clear is;
end

类别

在 Help Center 和 File Exchange 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by