Get Blob from Firebird SQL Database

7 次查看（过去 30 天）
Rene Bilsing
Rene Bilsing 2019-2-11
回答： Rene Bilsing 2019-2-11
Hi all,
I'm trying to read a blob with help of a JDBC driver out of a Firebird SQL database. The normal SQL query are working as expected but as soon as I want to read blob, I get this kind of result: org.firebirdsql.jdbc.FBBlob@24027b42. The value after the "@" sign is changing after each try. I'm tried both, accessing the blob with help of the database explorer of the database toolbox and with a script. The result is very similar.
For me it looks like that the result is referring to any kind of address but I don't know how to access the data.
Any kind of help is appreciated. Thanks in advance.
  4 个评论
显示 2更早的评论
Guillaume
Guillaume 2019-2-11
编辑：Guillaume 2019-2-11
Ok then, what is the class of the content of that cell?
class(rsdata{1})
Rene Bilsing
Rene Bilsing 2019-2-11
class(rsdata{1})
ans =
org.firebirdsql.jdbc.FBBlob

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2019-2-11
So, what you're getting back is a java object of type org.firebirdsql.jdbc.FBBlob. You can use the methods of that object to get information about the blob and access the actual data. Most likely:
blobdata = rsdata{1}.getBytes(1, 0); %Get from 1st byte of length 0
I'm assuming that length 0 means everything, if not:
blobdata = rsdata{1}.getBytes(1, rsdata{1}.length()); %length is the length of the blob

更多回答（1 个）

Rene Bilsing
Rene Bilsing 2019-2-11
Exactly what I was looking for. Thanks!

类别

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

标签

产品


版本

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by