Get Blob from Firebird SQL Database
显示 更早的评论
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 个评论
Guillaume
2019-2-11
What is
class(the_blob_object_returned_by_your_query)
?
Rene Bilsing
2019-2-11
Ok then, what is the class of the content of that cell?
class(rsdata{1})
Rene Bilsing
2019-2-11
采纳的回答
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 个）
类别
在 帮助中心 和 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 
