Re: import_bytea function

Stephen Davies schrieb am 07.10.2016 um 10:46:
>> You can store the contents of a file in a bytea using plain JDBC no lo_import() required
>>
>>     String sql = "insert into images (id, image_data) values (?,?)";
>>     Connection con = ....;
>>     File uploaded = new File("...");
>>     InputStream in = new FileInputStream(uploaded);
>>     PreparedStatement pstmt = con.prepareStatement(sql);
>>     pstmt.setInt(1, 42);
>>     pstmt.setBinaryStream(in, (int)uploaded.length());
>>     pstmt.executeUpdate();
>>
>> This *only* works with bytea column, not with "large objects".
>>
>> In production code you obviously need to close all resources and handle errors.
>> I left that out for simplicity.

> That looks reasonable but I need to update rather than insert and my similar
> code with sql="update part set pic=? where id=3" did not work.

That *will* work (using that myself for updates as well).

What exactly is your problem? What was the error/exception?