Forums:

Saving a jpg image to derby Blob

Ranch Hand

Posts: 74

posted 6 months ago

Number of slices to send:

Optional 'thank-you' note:

Send

I have been able to upload a jpg image and display it within a jlabel. Somehow, the image doesn't save to the derby database which consists of 3 fields: SLIDEID, SLIDENAME, IMAGEJPG. the first two are string and the last one (IMAGEJPG) is a Blob. I have tried various tutorials with no effect. Just need the jpg image saved to the derby database. This is part of my original progam for developing an interactive tasks slide images with step by step directives. The program does load the images with no problem --just doesn't insert it into the database.

public void SearchAndSave() throws FileNotFoundException, IOException, ClassNotFoundException, SQLException {
PreparedStatement psts1 = null;
Connection conn=null;
Statement stmt;

newslideId = jtxtfld_SlideId.getText();//EXAMPLE: Ethos1 (use the product SKU number??)

Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
    //  set default directory from JFileChooser

JFileChooser fc = new JFileChooser(Path);
    fc.setAccessory(new ImagePreviewComponent(fc));      
    int returnVal = fc.showOpenDialog(null);
    if (returnVal == JFileChooser.APPROVE_OPTION) {
        try {
            File file = fc.getSelectedFile();
            String dir = file.getAbsolutePath();
            ImageIcon icon = new ImageIcon(dir);
            String fname = file.getName();
            jlbl_Display.setText("");  // 
            jlbl_Display.setIcon(icon);
            jtxtfld_SlideName.setText(fname);
            
            FileInputStream FileInputStream = new FileInputStream(file);
            
        try{            
            String set2db = JOptionPane.showInputDialog("Save image ? ((y/n))");
            if (set2db.equals("y")) {
              
              String addSQL1 = "INSERT INTO ETHOSSLIDE( SLIDEID, SLIDENAME, IMAGEJPG  ) VALUES (?, ?, ?)";
              
              
               PreparedStatement pstsl = conn.prepareStatement(addSQL1);
               
              
                Blob blob = conn.createBlob();
                
                    ObjectOutputStream oos;
                    oos = new ObjectOutputStream(blob.setBinaryStream(1));
                    oos.writeObject(icon);
                    oos.close();
                    pstsl.setString(1, newslideId);
                    pstsl.setString(2, newslideName);
                    pstsl.setBlob(3, blob);
                    pstsl.executeUpdate();
            
                    if (pstsl.executeUpdate() > 0)
                        JOptionPane.showMessageDialog(null, "Image is saved");
                    else
                        JOptionPane.showMessageDialog(null, "Not saved");
                    blob.free();
                    psts1.close();
           
            }      
    }catch (FileNotFoundException ex) {                         
            Logger.getLogger(ImageSaver.class.getName()).log(Level.SEVERE, null, ex);
        }

}catch( HeadlessException | IOException | SQLException e){}

}
}

Carey Brown

Saloon Keeper

Posts: 10797