Get Blob from Firebird SQL Database
6 views (last 30 days)
Show older comments
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 Comments
Accepted Answer
Guillaume
on 11 Feb 2019
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
0 Comments
More Answers (1)
See Also
Categories
Find more on Database Toolbox in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!