Subject Re: blobs in JBuilder with the firebirdsql driver
Author llafranc78
Hi!

I think the best way to insert blobs is using a
PreparedStatement.setBinaryStream(int index,InputStream is,int length).
I use this system with all dbs I work with. It should work for
Firebird, too.
Something like this should work:

File bitmap = new File("test.bmp");
FileInputStream fis = new FileInputStream(bitmap);

PreparedStatement pstmt = connection.prepareStatement("insert into
mytable (blob_col) values (?)");

pstmt.setBinaryStream(1,fis,bitmap.length());

pstmt.executeUpdate();
pstmt.close();

Ciao
Luca