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.

[Guillaume]

What is

class(the_blob_object_returned_by_your_query)

?

[Rene Bilsing]

The class is of the data is a cell.

Name Size Bytes Class Attributes

rsdata 1x1 112 cell

[Guillaume]

Ok then, what is the class of the content of that cell?

class(rsdata{1})

[Rene Bilsing]

class(rsdata{1})

ans =

org.firebirdsql.jdbc.FBBlob

Answer 1

[Guillaume]

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

Answer 2

[Rene Bilsing]

Exactly what I was looking for. Thanks!