Get Blob from Firebird SQL Database

7 vues (au cours des 30 derniers jours)
Rene Bilsing
Rene Bilsing le 11 Fév 2019
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 commentaires
Guillaume
Guillaume le 11 Fév 2019
Modifié(e) : Guillaume le 11 Fév 2019
Ok then, what is the class of the content of that cell?
class(rsdata{1})
Rene Bilsing
Rene Bilsing le 11 Fév 2019
class(rsdata{1})
ans =
org.firebirdsql.jdbc.FBBlob

Connectez-vous pour commenter.

Réponse acceptée

Guillaume
Guillaume le 11 Fév 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

Plus de réponses (1)

Rene Bilsing
Rene Bilsing le 11 Fév 2019
Exactly what I was looking for. Thanks!

Produits


Version

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by