I inserted 3 blob (images) in derby blob column….One blob first time, then other entry inserted 2 blobs ...the blobs inserted in one row .
blob.getLength() ,gives me the exact bytes size of the 3 blob( images) combined, which suggests to me that the 3 blobs have been saved in DB.
Then I try get :
byteArray = blob.getBytes(0,blob.length());
imageIcon=new ImageIcon(byteArray);
Or
inputStream =blob.getBinaryStream();
BufferedImage image=ImageIO.read(inputStream);
imageIcon= new ImageIcon(image);
whichever I use , I get only the first blob (image) shows on the Jpanel… what blocks the other blobs from being read and show ?
private JTextPane createMediaArea() {
String getMediaEditorData = "select mediaEditor from settingsTable where id=6";
Statement stmtBlob;
try {
stmtBlob = settingsConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
try (ResultSet rsMediaEditor = stmtBlob.executeQuery(getMediaEditorData)) {
System.out.println("rsMediaEditor is created ");
while (rsMediaEditor.next()) {
mediaEditorBlob = rsMediaEditor.getBlob("mediaEditor");
if (mediaEditorBlob == null) {
chosenImageIcon = new ImageIcon("./resources.jpg");
scaledChosenImage = chosenImageIcon.getImage().getScaledInstance(100, 100, Image.SCALE_FAST);
scaledImageIcon = new ImageIcon(scaledChosenImage);
mediaArea.insertIcon(scaledImageIcon);
} else {
mediaEditorBlobLength = mediaEditorBlob.length();
System.out.println("mediaEditorBlobLength is : " + mediaEditorBlobLength);
/*1st way is to get the blob array .*/
/*
byte[] mediaEditorByteArray = mediaEditorBlob.getBytes(1L, (int) mediaEditorBlobLength);
int mediaEditorByteArrayLength = mediaEditorByteArray.length;
System.out.println("mediaEditorByteArrayLength is :" + mediaEditorByteArrayLength);
*/
/*2nd way ..use ImageIO*/
InputStream binaryStream = mediaEditorBlob.getBinaryStream();
BufferedImage read = ImageIO.read(binaryStream);
chosenImageIcon= new ImageIcon(read);
scaledChosenImage = chosenImageIcon.getImage().getScaledInstance(100, 100, Image.SCALE_FAST);
scaledImageIcon = new ImageIcon(scaledChosenImage);
mediaArea.insertIcon(scaledImageIcon);
}
}
} catch (IOException ex) {
Logger.getLogger(FrontFace.class.getName()).log(Level.SEVERE, null, ex);
}
System.out.println("rsMediaEditor closed !");
stmtBlob.close();
System.out.println("stmtBlob closed !");
} catch (SQLException ex) {
Logger.getLogger(FrontFace.class.getName()).log(Level.SEVERE, null, ex);
}
return mediaArea;
}
In java we use jdbc to interact with databases. See here for examples https://docs.oracle.com/javase/tutorial/jdbc/.
And jdbc is used to retrieve database rows into java objects.