Cannot delete data from a table using hibernate

Question

I tried many methods on the net, but it doesn't work. I want to delete data from a database using hibernate, but I get this errors SEVERE: Cannot delete or update a parent row: a foreign key constraint fails (sakila.comanda, CONSTRAINT comanda_ibfk_1 FOREIGN KEY (IDPRODUS) REFERENCES produs (IDPRODUS)) SEVERE: Could not synchronize database state with session

comanda means order and produs means product

Here is the code:

    private void StergeButtonActionPerformed(java.awt.event.ActionEvent evt) {
    try{
        org.hibernate.Transaction tx = session.beginTransaction();

        int idprodus = ((Produs)IdProdusComboBox.getSelectedItem()).getIdprodus();
        Produs produs = (Produs) session.get(Produs.class, idprodus);

        session.delete(produs);

        tx.commit();
    }catch(Exception e){
        System.out.println(e.getMessage());
    }
}

You have posted the mapping of "comanda" twice and the mapping of "produs" is missing. — Pino
– Pino, Commented May 28, 2012 at 8:53

JB Nizet · Accepted Answer · 2012-05-28 08:48:53Z

2

This just means that deleting the product is impossible, because it would break a foreign key constraint in database. You have orders for your product, but you're trying to delete the product. How will you honor the orders? You have to decide:

either you delete the orders referencing the product before deleting the product
or you keep the orders in the database, but these orders must not reference the product anymore.

Not doing any of the above would leave the database in an inconsistent state: orders for products which don't exist. The foreign key constraint in the database ensures that such an inconsistent state is impossible.

answered May 28, 2012 at 8:48

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

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

Collectives™ on Stack Overflow

Cannot delete data from a table using hibernate

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