How to insert file into Firebird BLOB using Java

Assuming that you have set up a database alias named TEST with a table named FILES:

CREATE TABLE files( content BLOB sub_type 0 );

Java code would look like this:

Connection c = DriverManager.openConnection(
"jdbc:firebirdsql:localhost/3050:test",
"SYSDBA",
"masterkey");

try {
PreparedStatement stmt = c.prepareStatement(INSERT INTO files VALUES(?)");

try {
stmt.setInputStream(1, new FileInputStream("c:/pic.jpg"));
stmt.executeUpdate();
} finally { stmt.close(); }

} finally { c.close(); }