Le portail francophone de la géomatique

 public static void main(String[] args) throws Exception {
        // TODO code application logic here
        Class.forName("org.postgresql.Driver");
        String url = "jdbc:postgresql://localhost:5433/postgis?user=nicolas";
        Connection conn = DriverManager.getConnection(url);

        File file = new File("/tmp/toto.pdf");
        FileInputStream fis = new FileInputStream(file);

        //
        // table test crée avec la commande:
        // create table test(id serial primary key, pdf bytea);
        //
        String query = "insert into test(pdf) values (?)";
        PreparedStatement ps = conn.prepareStatement(query);
        ps.setBinaryStream(1, fis, (int) file.length());
        ps.executeUpdate();
        ps.close();
        fis.close();

        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("select * from test");

        while (rs.next()) {
            String blob = new String(rs.getBytes(2));
            //System.out.println("record id: " + rs.getInt(1) + " : " + blob);
            System.out.println("record id: " + rs.getInt(1) + " : " + blob.length());
        }
        stmt.close();
        conn.close();
    }