Subject | Re: blobs in JBuilder with the firebirdsql driver |
---|---|
Author | llafranc78 |
Post date | 2002-02-05T10:45:36Z |
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
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