Unable to display image from database to tableview

It starts with the class that serves as the data model for the TableView. In the below code, that class is ImagItem. The class must contain an attribute for each column of the TableView – which must be an ObservableValue. In the below code, there is only one column. Hence class ImagItem contains a single attribute. For each attribute you need three methods.

• One that returns the value wrapped by the ObservableValue.
• One that assigns the wrapped value.
• One that returns the ObservableValue.

Now you just need to define the cell value factory and the cell factory for the columns of the TableView. The cell value factory is basically a method that receives a CellDataFeatures and returns an ObservableValue. In the below code, in the lambda expression that serves as that method, c is an instance of CellDataFeatures<ImagItem, Image> and its getValue method returns an instance of ImagItem, so you want that method to return the attribute of ImagItem – hence the call to imageProperty. Note that the names of the methods in class ImagItem are according to the accepted convention.

Finally, the cell factory is a method that receives a TableColumn and needs to return a TableCell. In the below code I have written an anonymous inner class which implicitly extends class TableCell and I have overridden method updateItem. TableCell extends Labeled and hence has a text property and a graphic property. You want your TableCell to display an image only, hence, in the below code, I simply wrap the method parameter (img) in an ImageView and set that as the graphic for the TableCell.

import java.net.MalformedURLException;
import java.net.URI;
import java.net.URL;
import java.nio.file.Path;
import java.nio.file.Paths;
import java.util.ArrayList;
import java.util.List;

import javafx.application.Application;
import javafx.beans.property.SimpleObjectProperty;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.scene.Group;
import javafx.scene.Scene;
import javafx.scene.control.TableCell;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.image.Image;
import javafx.scene.image.ImageView;
import javafx.stage.Stage;

public class Test extends Application {
    private static final Path  ROOT = Paths.get("C:\\Users\\USER\\Pictures");

    @Override
    public void start(Stage primaryStage) throws Exception {
        Group root = new Group();
        TableView<ImagItem> table = new TableView<ImagItem>();
        TableColumn<ImagItem, Image> imgCol = new TableColumn<ImagItem, Image>("Image");
        imgCol.setCellValueFactory(c -> c.getValue().imageProperty());
        imgCol.setCellFactory(c -> {
            return new TableCell<ImagItem, Image>() {
                protected void updateItem(Image img, boolean empty) {
                    super.updateItem(img, empty);
                    setText(null);
                    if (img != null  &&  !empty) {
                        ImageView imgVw = new ImageView(img);
                        setGraphic(imgVw);
                    }
                    else {
                        setGraphic(null);
                    }
                }
            };
        });
        table.getColumns().add(imgCol);
        ObservableList<ImagItem> items = FXCollections.observableArrayList(getImages());
        table.setItems(items);
        root.getChildren().add(table);
        Scene scene = new Scene(root);
        primaryStage.setScene(scene);
        primaryStage.show();
    }

    private ImagItem getImage(String name) throws MalformedURLException {
        Path path = ROOT.resolve(name);
        URI uri = path.toUri();
        URL url = uri.toURL();
        Image img = new Image(url.toExternalForm());
        ImagItem ii = new ImagItem(img);
        return ii;
    }

    private List<ImagItem> getImages() throws MalformedURLException {
        List<ImagItem> list = new ArrayList<>();
        list.add(getImage("284kd.png"));
        list.add(getImage("dynamite.png"));
        return list;
    }

    public static void main(String[] args) {
        launch(args);
    }
}

class ImagItem {
    private SimpleObjectProperty<Image>  image;

    public ImagItem(Image img) {
        image = new SimpleObjectProperty<Image>(this, "image", img);
    }

    public Image getImage() {
        return image.get();
    }

    public void setImage(Image img) {
        image.set(img);
    }

    public SimpleObjectProperty<Image> imageProperty() {
        return image;
    }
}

Here is a screen capture:

Edit

(19 January 2024)
The images were not displayed for you because you probably did not insert them correctly into the database. The below code demonstrates how to update the images in the database (because I assume that you have already inserted them – albeit incorrectly).

For inserting, refer to the accepted answer in this SO question:
How to write / update Oracle blob in a reliable way?

I adapted that answer to update the database (because I also initially incorrectly inserted the images into the database).

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class UpdImOra {

    public static void main(String[] args) {
        if (args.length < 2) {
            System.out.println("ARGS: file, id");
            System.exit(1);
        }
        File f = new File(args[0]);
        long len = f.length();
        int id = Integer.parseInt(args[1]);
        String sql = """
update PROPERTIES
   set IMAGE = ?
 where ID = ?
                """;
        try (Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//host:1521/sid",
                                                           "George",
                                                           "Best");
             FileInputStream fis = new FileInputStream(f);
             PreparedStatement ps = conn.prepareStatement(sql)) {
            ps.setBinaryStream(1, fis, len);
            ps.setInt(2, id);
            int count = ps.executeUpdate();
            String plural = count == 1 ? "" : "s";
            System.out.printf("Updated %d row%s.%n", count, plural);
        }
        catch (IOException | SQLException x) {
            x.printStackTrace();
        }

    }
}

Now the images are displayed in the TableView.

import java.io.InputStream;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import javafx.application.Application;
import javafx.beans.property.SimpleObjectProperty;
import javafx.beans.property.SimpleStringProperty;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.scene.Scene;
import javafx.scene.control.TableCell;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.image.Image;
import javafx.scene.image.ImageView;
import javafx.scene.layout.BorderPane;
import javafx.stage.Stage;

public class OraFxApp extends Application {

    @Override
    public void start(Stage primaryStage) throws Exception {
        TableView<Property> table = new TableView<>();
        TableColumn<Property, Number> idCol = new TableColumn<>("ID");
        idCol.setCellValueFactory(c -> c.getValue().idProperty());
        TableColumn<Property, String> propertyCol = new TableColumn<>("PROPERTY");
        propertyCol.setCellValueFactory(c -> c.getValue().propertyProperty());
        TableColumn<Property, Image> imageCol = new TableColumn<>("IMAGE");
        imageCol.setCellValueFactory(c -> c.getValue().imageProperty());
        imageCol.setCellFactory(c -> {
            return new TableCell<Property, Image>() {
                protected void updateItem(Image img, boolean empty) {
                    super.updateItem(img, empty);
                    setText(null);
                    if (img != null  &&  !empty) {
                        ImageView imgVw = new ImageView(img);
                        setGraphic(imgVw);
                    }
                    else {
                        setGraphic(null);
                    }
                }
            };
        });
        TableColumn<Property, Number> priceCol = new TableColumn<>("PRICE");
        priceCol.setCellValueFactory(c -> c.getValue().priceProperty());
        TableColumn<Property, String> contactCol = new TableColumn<>("CONTACT");
        contactCol.setCellValueFactory(c -> c.getValue().contactProperty());
        TableColumn<Property, String> locationCol = new TableColumn<>("LOCATION");
        locationCol.setCellValueFactory(c -> c.getValue().locationProperty());
        TableColumn<Property, String> statusCol = new TableColumn<>("STATUS");
        statusCol.setCellValueFactory(c -> c.getValue().statusProperty());
        ObservableList<TableColumn<Property, ?>> columns = table.getColumns();
        columns.add(idCol);
        columns.add(propertyCol);
        columns.add(imageCol);
        columns.add(priceCol);
        columns.add(contactCol);
        columns.add(locationCol);
        columns.add(statusCol);
        List<Property> list = loadPropertyData();
        ObservableList<Property> items = FXCollections.observableArrayList(list);
        table.setItems(items);
        BorderPane root = new BorderPane();
        root.setCenter(table);
        Scene scene = new Scene(root);
        primaryStage.setScene(scene);
        primaryStage.show();
    }

    private List<Property> loadPropertyData() throws SQLException {
        String sql = """
select ID
      ,PROPERTY
      ,IMAGE
      ,PRICE
      ,CONTACT
      ,LOCATION
      ,STATUS
  from PROPERTIES
                """;
        List<Property> list = new ArrayList<>();
        try (Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//host:1521/sid",
                                                           "George",
                                                           "Best");
             Statement s = conn.createStatement();
             ResultSet rs = s.executeQuery(sql)) {
            while (rs.next()) {
                int iden = rs.getInt(1);
                String prop = rs.getString(2);
                Blob blob = rs.getBlob(3);
                InputStream is = blob.getBinaryStream();
                Image img = new Image(is);
                int cost = rs.getInt(4);
                String liaison = rs.getString(5);
                String place = rs.getString(6);
                String situation = rs.getString(7);
                Property p = new Property(iden, prop, img, cost, liaison, place, situation);
                list.add(p);
            }
        }
        return list;
    }

    public static void main(String[] args) {
        launch(args);
    }
}

class Property {
    private SimpleObjectProperty<Number>  id;
    private SimpleStringProperty  property;
    private SimpleObjectProperty<Image>  image;
    private SimpleObjectProperty<Number>  price;
    private SimpleStringProperty  contact;
    private SimpleStringProperty  location;
    private SimpleStringProperty  status;

    public Property(int iden,
                    String prop,
                    Image  img,
                    int    cost,
                    String liaison,
                    String place,
                    String situation) {
        id = new SimpleObjectProperty<>(this, "id", Integer.valueOf(iden));
        property = new SimpleStringProperty(this, "property", prop);
        image = new SimpleObjectProperty<>(this, "image", img);
        price = new SimpleObjectProperty<>(this, "price", Integer.valueOf(cost));
        contact = new SimpleStringProperty(this, "contact", liaison);
        location = new SimpleStringProperty(this, "location", place);
        status = new SimpleStringProperty(this, "status", situation);
    }

    public Number getId() {
        return id.get();
    }

    public void setId(Number iden) {
        id.set(iden);
    }

    public SimpleObjectProperty<Number> idProperty() {
        return id;
    }

    public String getProperty() {
        return property.get();
    }

    public void setProperty(String prop) {
        property.set(prop);
    }

    public SimpleStringProperty propertyProperty() {
        return property;
    }

    public Image getImage() {
        return image.get();
    }

    public void setImage(Image img) {
        image.set(img);
    }

    public SimpleObjectProperty<Image> imageProperty() {
        return image;
    }

    public Number getPrice() {
        return price.get();
    }

    public void setPrice(Number iden) {
        price.set(iden);
    }

    public SimpleObjectProperty<Number> priceProperty() {
        return price;
    }

    public String getContact() {
        return contact.get();
    }

    public void setContact(String prop) {
        contact.set(prop);
    }

    public SimpleStringProperty contactProperty() {
        return contact;
    }

    public String getLocation() {
        return location.get();
    }

    public void setLocation(String prop) {
        location.set(prop);
    }

    public SimpleStringProperty locationProperty() {
        return location;
    }

    public String getStatus() {
        return status.get();
    }

    public void setStatus(String prop) {
        status.set(prop);
    }

    public SimpleStringProperty statusProperty() {
        return status;
    }
}

Screen capture: