Saving images to Postgresql Java

Question

I'm trying to save an image in a postgresql table

//table schema
CREATE TABLE public.hp_xray_results
(
  patient_no character varying(70),
  xray_image bytea
)

java.sql.PreparedStatement pstmt = connectDB.prepareStatement("INSERT INTO hp_xray_results (patient_no,xray_image) VALUES(?,?)");
pstmt.setString(1, jTextField36.getText());

File file = new File(String.valueOf(jTable3.getValueAt(i, 4)));
FileInputStream fis=null;
try {
    fis = new FileInputStream(file);
} catch (FileNotFoundException ex) {
    ex.printStackTrace();
    Exceptions.printStackTrace(ex);
}

pstmt.setBinaryStream(2, fis, (int) file.length());
try {
    fis.close();
} catch (IOException ex) {
    ex.printStackTrace();
    Exceptions.printStackTrace(ex);
}

pstmt.executeUpdate();

On running the above code, I get an exception. org.postgresql.util.PSQLException: Unable to bind parameter values for statement.

What improvements can I make?

It was 2 in the code, made a mistake while typing

Sam
– Sam

2017-01-12 11:25:41 +00:00
Commented Jan 12, 2017 at 11:25 — Sam
– Sam, Commented Jan 12, 2017 at 11:25

Yaroslav Stavnichiy · Accepted Answer · 2017-01-12 11:10:39Z

1

Replace all your code with the following:

File file = new File(...);
String sql = "INSERT INTO hp_xray_results (patient_no,xray_image) VALUES(?,?)";
try (PreparedStatement pstmt = connectDB.prepareStatement(sql);
     FileInputStream fis = new FileInputStream(file)) {
    pstmt.setString(1, jTextField36.getText());
    pstmt.setBinaryStream(2, fis, (int) file.length());
    pstmt.executeUpdate();
} catch (Exception e) {
    ...
}

Documentation links:

answered Jan 12, 2017 at 11:10

Yaroslav Stavnichiy

21.5k6 gold badges55 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Saving images to Postgresql Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related